原始:START WITH a.org_id = b.dept_id
CONNECT BY PRIOR org_id = org_parent_id
To:
WITH RECURSIVE cte AS (
SELECT ... WHERE a.org_id =b.dept_id
UNION ALL
(c.org_id = a.org_parent_id
SELECT ... FROM ... JOIN cte c ON (c.prior org_id = a.org_parent_id)
)
true:
WITH RECURSIVE cte AS (
SELECT ... WHERE a.org_id = b.dept_id
SELECT ... FROM ... JOIN cte c ON (c.org_id = a.org_parent_id)
)