mysql 单表递归树图

最新推荐文章于 2022-06-21 09:35:03 发布

北野木

最新推荐文章于 2022-06-21 09:35:03 发布

阅读量237

点赞数

文章标签： mysql sql

本文链接：https://blog.csdn.net/qq_40812553/article/details/106402312

版权

第一步拿到所有第一级通id=p_id 获得所有子集（可自行修改适合自己）

SELECT DATA
   .id 'key',
   DATA.id AS 'value',
   DATA.type_name AS 'title',
   DATA.parent_id,
   DATA.has_son AS hasSon
FROM
   (
   SELECT
       @ids AS _ids,
       ( SELECT @ids := GROUP_CONCAT( id ) FROM shs_system_manager.sort_dictionary WHERE FIND_IN_SET( parent_id, @ids ) ) AS cids,
       @l := @l + 1 AS LEVEL
   FROM
       shs_system_manager.sort_dictionary,
       ( SELECT @ids := 第一级的id , @l := 0 ) b
   WHERE
       @ids IS NOT NULL
   ) id,
   shs_system_manager.sort_dictionary DATA
WHERE
   FIND_IN_SET( DATA.id, id._ids )
AND ( system_id LIKE '%,2,%' OR system_id LIKE '%2%' )