JZTXT

mysql 递归查询示例

发布时间 2023-09-14 16:07:56作者: 20211103

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;