mysql 的递归方法 查询pid为 5246

select ID ,name from (
              select t1.ID,t1.PARENTID,name,
              if(find_in_set(PARENTID, @pids) > 0, @pids := concat(@pids, ',', ID), 0) as ischild
              from (
                   select t.ID,PARENTID,t.NAME as name from hn_cultivate_department t  order by PARENTID, ID
                  ) t1,
                  (select @pids := 5246) t2
             ) t3 where ischild != 0