题目地址

https://leetcode.cn/problems/all-people-report-to-the-given-manager/description/

代码

WITH RECURSIVE cte_subordinates AS (
    -- 基础情况: 找到直接下属
    SELECT employee_id 
    FROM Employees 
    WHERE manager_id = 1
    UNION
    -- 递归情况: 找到下属的下属
    SELECT t.employee_id 
    FROM Employees  t
    INNER JOIN cte_subordinates s ON t.manager_id = s.employee_id
)
SELECT employee_id FROM cte_subordinates
where employee_id <>1