id ，parent_id 上下级的定义 select id from ( select t1.id,t1.parent_id, if(find_in_set(parent_id, @pids) > 0, @pids := concat(@pids, ',', id), 0) as ischild