mysql根据父id向下查询所有的子节点
SELECT
ID ,父级ID,节点名称
FROM
(
SELECT
t1.ID,t1.父级ID,t1.节点名称,
IF
( find_in_set( 父级ID, @pids ) > 0, @pids := concat( @pids, ',', ID ), -1 ) AS ischild
FROM
( SELECT ID, 父级ID,节点名称 FROM 表名 t) t1,
( SELECT @pids := 查询ID ) t2
) t3
WHERE
ischild != -1