mysql recursively queryes all child nodes based on the parent node
Making a piece of heaven: select dept_id from ( 2 select t1.dept_id, t1.parent_id, 3 if(find_in_set(parent_id, @pids) > 0, @pids := concat(@pids, ',', dept_id), 0) as ischild 4 from ( 5 select dept_id,parent_id from sys_dept t where t.del_flag = '0' order by parent_id,dept_id 6) t1, 7 (select @pids := node id to query) t2 union all select dept_id,parent_id from sys_dept where org_brnch_code=id of node to be queryed 8 ) t3 where ischild != 0; order by ischild