mysql 获取每日新增总数量

SELECT DATE_FORMAT(createTime,'%Y-%m-%d') as time , count(*) as count FROM member GROUP BY  time;