mysql两个表递归_mysql 单表递归树图

第一步拿到所有第一级  通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%' )

效果