用于获取部门代码的SQL递归查询

WITH RECURSIVE DepartmentHierarchy AS (
    SELECT
        department_id,
        department_name,
        parent_department_id
    FROM
        departments
    WHERE
        department_id = '目标部门ID'
    
    UNION ALL
    
    SELECT
        d.department_id,
        d.department_name,
        d.parent_department_id
    FROM
        departments d
    INNER JOIN
        DepartmentHierarchy dh ON d.department_id = dh.parent_department_id
)
SELECT
    *
FROM
    DepartmentHierarchy;