mysql循环递归查询

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

WITH RECURSIVE employee_hierarchy AS (
    -- Anchor member: select the initial employee
    SELECT id, name, manager_id, 1 AS level
    FROM employees
    WHERE id = ? -- Replace ? with the target employee ID
    
    UNION ALL
    
    -- Recursive member: select subordinates of the current employee
    SELECT e.id, e.name, e.manager_id, eh.level + 1
    FROM employees e
    INNER JOIN employee_hierarchy eh ON e.manager_id = eh.id
)
SELECT * FROM employee_hierarchy;

WITH RECURSIVE employee_hierarchy AS (
    ...
    LIMIT 100 -- 设置最大递归深度
)