1、数据库表 sys_user sys_dept 2、实现查询,使用字符串拼接函数concat select * FROM sys_dept sd WHERE dept_id = (SELECT dept_id FROM sys_user su WHERE user_id = '1') or ancestors LIKE concat('%',(SELECT dept_id FROM sys_user su WHERE user_id = '1'),'%'); 3、结果