贴记录及要求结果出来看SELECT user.uid,count(*) FROM shared_users user LEFT JOIN `mama_webform_submissions` wb ON user.uid = wb.uid WHERE user.created BETWEEN 1298937600 AND 1301616000 group by user.uid ORDER BY user.uid ASC
Select user.uid,count(*) from shared_users user inner join `mama_webform_submissions` wb on user.uid = wb.uid Group by user.uid
FROM shared_users user
LEFT JOIN `mama_webform_submissions` wb ON user.uid = wb.uid
WHERE user.created
BETWEEN 1298937600
AND 1301616000
group by user.uid
ORDER BY user.uid ASC
Group by user.uid