SELECT
 count(*) num,
 DATE_FORMAT(create_time, '%Y-%m-%d') AS `day`
FROM
 sys_log
WHERE
  log_type = 1
AND create_time > DATE_SUB(NOW(), INTERVAL 10 DAY)
GROUP BY
  DATE_FORMAT(create_time, '%Y-%m-%d')