mysql支持树查询么

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

WITH RECURSIVE employee_tree AS (
    -- 初始查询：选择根节点（例如，员工ID为1的员工）
    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_tree et ON e.manager_id = et.id
)
SELECT * FROM employee_tree;

WITH RECURSIVE employee_tree 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_tree et ON e.manager_id = et.id
    -- 设置最大递归深度为10
    LIMIT 10
)
SELECT * FROM employee_tree;