mysql 递归查询示例

WITH RECURSIVE subordinates AS (
SELECT * FROM sys_dept WHERE dept_id = 1 -- 这里以员工ID为1为例
UNION ALL
SELECT e.* FROM sys_dept e INNER JOIN subordinates s ON e.dept_id = s.parent_id
)
SELECT * FROM subordinates;