select date_format(CREATEDAY,'%Y-%m-%d') as dates,count(*) as counts from members group by date_format(CREATEDAY,'%Y-%m-%d') 以上SQL统计每日新增会员数。