递归查询数据表
SELECT distinct * FROM (
SELECT id, parent_id,group_name FROM daily_work_group_info WHERE id = 25
UNION ALL
SELECT i.id, i.parent_id,group_name
FROM daily_work_group_info i
INNER JOIN (
SELECT * FROM (
SELECT id, parent_id FROM daily_work_group_info WHERE id = 25
UNION ALL
SELECT id, parent_id FROM daily_work_group_info WHERE parent_id = 25
) t1
) t2 ON i.parent_id = t2.id
) t3
原创2023/7/1小于 1 分钟