SELECT COUNT(0) total,DATE_FORMAT(bind_time,'%Y-%m-%d') TIME FROM t_member_card GROUP BY DATE_FORMAT(bind_time,'%Y-%m-%d') ORDER BY total DESC;