mysql 分级查询

SELECT e1.name AS employee_name, e2.name AS manager_name
FROM employees e1
JOIN employees e2 ON e1.manager_id = e2.id
WHERE e1.name = 'John Doe';

WITH RECURSIVE employee_hierarchy AS (
    SELECT id, name, manager_id
    FROM employees
    WHERE id = (SELECT id FROM employees WHERE name = 'John Doe')
    UNION ALL
    SELECT e.id, e.name, e.manager_id
    FROM employees e
    INNER JOIN employee_hierarchy eh ON e.id = eh.manager_id
)
SELECT name AS manager_name
FROM employee_hierarchy
WHERE id != (SELECT id FROM employees WHERE name = 'John Doe');