WITH N2 AS(

    SELECT n.ID, org."ParentID", n."NodeName", n."Sort" FROM "Organize" org

    LEFT JOIN "Node" n ON n."ID"=org."NodeID"

    WHERE n."DeleteTime" IS NULL AND n."RefreshTime" is NULL

    ORDER BY "ParentID", "Sort" ASC

)

    SELECT "ID",   "ParentID", "NodeName",

    SYS_CONNECT_BY_PATH("ID",'\')   ID_PATH, SYS_CONNECT_BY_PATH("NodeName",'\')  NAME_PATH, LEVEL, "Sort"

    FROM N2

    START   WITH "ParentID"='#' OR "ParentID" IS NULL

    CONNECT BY PRIOR "ID"="ParentID"

    order SIBLINGS by "Sort" ASC