1、获取近七天的数据
SELECT
click_date AS date,
IFNULL( people.total, 0 ) AS total
FROM
(
SELECT
click_date
FROM
(
SELECT
curdate( ) AS click_date UNION ALL
SELECT
date_sub( curdate( ), INTERVAL 1 DAY ) AS click_date UNION ALL
SELECT
date_sub( curdate( ), INTERVAL 2 DAY ) AS click_date UNION ALL
SELECT
date_sub( curdate