mysql 递归查询 版本8以上支持

 -- 查询子节点  含自己
WITH recursive temp AS(
    SELECT id FROM gg_zz WHERE id = ' '
    UNION ALL
    SELECT zz.id FROM gg_zz zz,temp t WHERE zz.fjd=t.id
)
SELECT id FROM temp

 -- 查询父节点  含自己
WITH recursive temp AS(
    SELECT fjd FROM gg_zz WHERE id = ' '
    UNION ALL
    SELECT zz.fjd FROM gg_zz zz,temp t WHERE zz.id=t.fjd
)
SELECT fjd FROM temp