#查询id=62的所有子节点
WITH RECURSIVE temp AS (
SELECT * FROM tbsys_office o WHERE o.id=62
UNION ALL
SELECT o.* FROM tbsys_office o,temp t WHERE t.id=o.parent_id
) SELECT * FROM temp;
#查询id=80的所有父节点
WITH RECURSIVE temp AS (
SELECT * FROM tbsys_office o WHERE o.id=80
UNION ALL
SELECT o.* FROM tbsys_office o,temp t WHERE t.parent_id=o.id
) SELECT * FROM temp;