mysql 视图递归单位

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

WITH RECURSIVE employee_hierarchy AS (
    -- 非递归部分：选择起始员工
    SELECT id, name, manager_id
    FROM employees
    WHERE id = 1 -- 假设我们要查询员工ID为1的员工及其下属

    UNION ALL

    -- 递归部分：选择下属员工
    SELECT e.id, e.name, e.manager_id
    FROM employees e
    INNER JOIN employee_hierarchy eh ON e.manager_id = eh.id
)
SELECT * FROM employee_hierarchy;

WITH RECURSIVE employee_hierarchy AS (
    SELECT id, name, manager_id
    FROM employees
    WHERE id = 1

    UNION ALL

    SELECT e.id, e.name, e.manager_id
    FROM employees e
    INNER JOIN employee_hierarchy eh ON e.manager_id = eh.id
    LIMIT 10
)
SELECT * FROM employee_hierarchy;