in ,count
SELECT
a.user_name,
a.user_id,
b.online_state ,
z.task_user_uuid ,
z.pay_priority ,
z.yiLingQuStatus ,
z.yiWanChengStatus ,
z.total
FROM
sys_user a
LEFT JOIN biz_document_user_info b ON a.uuid = b.user_id
LEFT JOIN (SELECT
b.user_uuid as task_user_uuid ,
COUNT(case WHEN d.pay_priority = 1 THEN '急单个数' end) AS pay_priority,
COUNT(case WHEN a.status ='已领取' THEN '已领取个数' end) as yiLingQuStatus ,
COUNT(case WHEN a.status ='已完成' THEN '已完成个数' end) as yiWanChengStatus ,
COUNT(case WHEN a.status IN('已完成','已领取') THEN '已完成个数' end) as total
FROM
bpm_activity a
LEFT JOIN bpm_task_user b on a.task_id = b.task_id
LEFT JOIN bpm_process_instance c on a.instance_id = c.instance_id
LEFT JOIN biz_pay_comfirm_info d on c.biz_uuid = d.uuid
where a.ACTIVITY_NAME in ('单证线上初审','单证线上初审','单证线下纸质审核','单证审核纸质资料','单证线上审核','项目单证线下纸质审核')
and a.sys_status =b.sys_status =c.sys_status=d.sys_status=1
GROUP BY b.user_uuid
) z on a.user_id = z.task_user_uuid
WHERE a.sys_status=b.sys_status =1