SELECT u2.abi_one_id,u2.real_name,apt.type_name, right(type_name, 1) as type_code,
u2.manager_emp_no,u2.employee_no, manager_name
FROM(
SELECT
@ids AS p_ids,
(SELECT @ids := GROUP_CONCAT(employee_no) FROM abi_user WHERE FIND_IN_SET(manager_emp_no, @ids)) AS c_ids,
@l := @l+1 AS LEVEL
FROM abi_user, (SELECT @ids := #{managerEmpNo}, @l := 0 ) b
WHERE @ids IS NOT NULL and abi_user.deleted = 0
) u1
JOIN abi_user u2
ON FIND_IN_SET(u2.employee_no, u1.p_ids)
LEFT JOIN abi_position_type apt ON u2.position_type_id = apt.id
where u2.deleted = 0 and apt.type_name is not null and employee_no != #{managerEmpNo}
参考:https://blog.youkuaiyun.com/weixin_43703769/article/details/109254934