查询指定节点和对应的父节点

WITH RECURSIVE cte AS (SELECT id, parent_id FROM xxx_dir WHERE id = 2 -- 当前节点的 IDUNION ALLSELECT t.id, t.parent_id FROM xxx_dir t JOIN cte c ON t.id = c.parent_id
)
SELECT DISTINCT id, parent_id FROM cte;