WITH RECURSIVE recursion AS (
-- 非递归部分
SELECT id, cate_name, parent_id
FROM inspect_item_cate
WHERE id = 548099996057784320 -- 这里替换为你想要查询的部门ID
UNION ALL
-- 递归部分
SELECT c.id, c.cate_name, c.parent_id
FROM inspect_item_cate c
INNER JOIN recursion dh ON c.parent_id = dh.id -- 关联当前部门的父ID与CTE中的ID
)
SELECT * FROM recursion;