sqlserver 查询一级部门

WITH cte AS (
        SELECT Id, supdepid, departmentname, 0 AS lv
        FROM HrmDepartment c
        WHERE id = '当前部门id'
        UNION ALL
        SELECT d.Id, d.supdepid, d.departmentname, lv + 1
        FROM cte c
            INNER JOIN HrmDepartment d ON c.supdepid = d.Id
    )
SELECT *
FROM cte
ORDER BY cte.lv DESC