查询所有下级条目

SELECT T1.id,T1.`status`,if(FIND_IN_SET(pid,@pids) > 0,@pids := CONCAT(@pids,',',id),0) as ischild
 FROM (SELECT id,pid,`status` FROM table T WHERE 1 = 1) T1,(SELECT @pids := {$id}) T2
 ) T3 WHERE ischild != 0 AND `status` != 0