mysql sql树形结构查询

CREATE TABLE employees (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    manager_id INT
);

WITH RECURSIVE employee_tree AS (
    -- Anchor member: select the initial employee
    SELECT id, name, manager_id
    FROM employees
    WHERE id = ? -- Replace ? with the employee ID you want to start from

    UNION ALL

    -- Recursive member: select all subordinates
    SELECT e.id, e.name, e.manager_id
    FROM employees e
    INNER JOIN employee_tree et ON e.manager_id = et.id
)
SELECT * FROM employee_tree;

SELECT e1.id, e1.name, e2.id, e2.name, e3.id, e3.name, ...
FROM employees e1
LEFT JOIN employees e2 ON e2.manager_id = e1.id
LEFT JOIN employees e3 ON e3.manager_id = e2.id
...
WHERE e1.id = ?; -- Replace ? with the employee ID you want to start from