#查询父编码及以下所有子节点
SELECT id FROM (
SELECT t1.id,t1.parent_id,IF (find_in_set(t1.id,@pids)> 0,@pids,IF (find_in_set(t1.parent_id,@pids)> 0,@pids :=CONCAT_WS(',',@pids,id),'0')) AS ischild,@pids FROM (
SELECT t.id,t.parent_id FROM hr_organization t WHERE t.STATUS=1 ORDER BY parent_id,id) t1,(
SELECT @pids :='YZC0035') t2) t3 WHERE ischild !='0';#查询子节点
SELECT id FROM (
SELECT t1.id,t1.parent_id, IF (find_in_set(t1.parent_id,@pids)> 0,@pids :=CONCAT_WS(',',@pids,id),'0') AS ischild,@pids FROM (
SELECT t.id,t.parent_id FROM hr_organization t WHERE t.STATUS=1 ORDER BY parent_id,id) t1,(
SELECT @pids :='YZC0035') t2) t3 WHERE ischild !='0';