语句查询:
WITH RECURSIVE cte AS (
SELECT * FROM mom_user.t_eap_sys_organization_real WHERE mom_user.t_eap_sys_organization_real.PARENT_ORG_REALATION_ID = "-1"
UNION ALL
SELECT mom_user.t_eap_sys_organization_real.* FROM mom_user.t_eap_sys_organization_real,cte WHERE cte.ORG_REALATION_ID = mom_user.t_eap_sys_organization_real.PARENT_ORG_REALATION_ID
) SELECT * FROM cte;
展现效果: