本文共 698 字,大约阅读时间需要 2 分钟。
WITH RECURSIVE cte AS ( SELECT edu.* FROM t_e_org_edu edu where edu.orgId = #{orgId} AND edu.status = '1' UNION ALL SELECT b.* FROM t_e_org_edu b INNER JOIN cte C ON b.parentorgid = C .orgid WHERE b.status = '1' ) SELECT * FROM cte WHERE 1 = 1 and orgtype = #{orgType}
转载于:https://www.cnblogs.com/scode2/p/9072042.html