一张表内递归SQL

WITH RECURSIVE cte AS
          ( SELECT tr.org_id, tr.parent_id, tr.org_name FROM epai_sys_dm.epai_sys_organization tr WHERE tr.org_id = 'ORGADG100000886'
            UNION SELECT t1.org_id, t1.parent_id, t1.org_name FROM epai_sys_dm.epai_sys_organization t1, cte WHERE t1.org_id = cte.parent_id )
            SELECT org_id, parent_id, org_name FROM cte

说明org_id是主键，parent_id 是父集ID
递归结果：