mysql递归查询节点下所有子节点

Question

数据表organ 主键id 名称name 父级id parent_uuid,类型object_type
查询父级id下所有数据
用了网上的方法 并不能得到，应该怎么写？

select id from (
              select t1.id,
              if(find_in_set(parent_uuid, @pids) > 0, @pids := concat(@pids, ',', id), 0) as ischild
              from (
                   select id,parent_uuid from organ t where t.object_type = '设备'
                  ) t1,
                  (select @pids := '11111' id) t2                            
             ) t3
where ischild != 0

Answer 1

SELECT au.id
FROM (SELECT * FROM organ  WHERE parent_uuid IS NOT NULL) au,
     (SELECT @pid := '11111') pd 
WHERE FIND_IN_SET(parent_uuid, @pid) > 0 
  AND @pid := concat(@pid, ',', id)