select year(eventTime),month(eventTime),day(eventTime),count(id) from table where eventTime>='***' and eventTime<'***'
group by year(eventTime),month(eventTime),day(eventTime)
SELECT DATE_FORMAT(eventTime,'%Y-%m-%d') AS data_date,COUNT(id) AS num FROM `table_txt`
WHERE eventTime >= '2019-06-03 11:00:00' AND eventTime <= '2019-06-08 13:00:00' GROUP BY data_date;