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