SELECT t3.id FROM
( SELECT *, IF (find_in_set(t1.parentId, @p) >0,@p:= concat(@p,',',id),0) AS childId FROM
(SELECT id,parentId FROM sys_menu t WHERE t.hidden = 0 ORDER BY id) t1,
(SELECT @p:= 40 ) t2 ) t3 WHERE childId != 0;
根据父节点查询出下面所有的子节点SELECT t3.id FROM ( SELECT *, IF (find_in_set(t1.parentId, @p) >0,@p:= concat(@p,',',id),0) AS childId FROM (SELECT id,parentId FROM sys_menu t WHERE t.hidden = 0 ORDER BY...