mysql递归连接所有节点名称_mysql 递归查找所有的子节点

" >

select * from (

select a.*, *, b.name as as department_name

from t_employee a left join t_department b on on a.department_idt_id = = b.id

) x

is_deleted = 0

and id = #{id,jdbcType=INTEGER}

and code = #{code,jdbcType=VARCHAR}

and name like concat('%',#{employeeName},'%')

and (department_id = #{departmentId,jdbcType=VARCHAR}

or department_id in (

select id from (

select ct t1.id,

,

if(find_in_set(parent_id, @pids) > 0, @pids := concat(@pids, ',', id), 0) as ischild

from (

select id,parent_id from t_department t where re t.is_del_deleted = 0

order by parent_id, id

) t1,

(select @pids := #{departmentId,jdbcType=VARCHAR}) t2

) t3 where ischild != 0

))

order by ${order}