摘要：WITH RECURSIVE x AS( SELECT * FROM t_org WHERE orgid = '10001' UNION ALL SELECT b.* FROM x,t_org b WHERE x.orgid = b.parentorgid AND b.status = '1' )S 阅读全文