select count(*)from (
(select
su.*
from sys_user su
left join sys_user_department sud on sud.user_id=su.id
where sud.department_id=#{id}
and role_id=2)as count)
select count(*) from 需要查询的数据表。 也可如图中拼接搜索语句
as 后面写的是查询出来的结果的表名,可自定义