WITH RECURSIVE org AS (
SELECT
root.*
FROM
dietary_food_directory root
WHERE
root.C_ID = '1' UNION
SELECT
child.*
FROM
dietary_food_directory child
JOIN org ON org.C_ID = child.C_PARENT_ID
) SELECT * FROM org
mysql 递归查询父级下面的子孙节点
最新推荐文章于 2023-06-17 13:55:39 发布