//这玩意好玩
SELECT
*
FROM
( SELECT * FROM TASK_TASK WHERE
parent_id > 0
ORDER BY parent_id, sort ) a,
(
SELECT
@pv := #{partentId} ) b
WHERE
(
FIND_IN_SET( parent_id, @pv )> 0
AND @pv := concat( @pv, ',', id ))
06-30
527