LEFT JOIN 多次同一个表
一条SQL返回多个count
SELECTpj_submit_keywords.user_id,org_user.email,org_user.nickname,COUNT(*) AStotal_count,SUM(CASE WHEN pj_submit_keywords.state=2 THEN 1 ELSE 0 END ) ASpass_count
FROM pj_submit_keywords
LEFT JOIN org_user ON org_user.user_id=pj_submit_keywords.user_id
GROUP BY pj_submit_keywords.user_id