SELECT
DATE( CREATE TIME ) 日期,
COUNT( USER_ID ) 每日新增用户
FROM
USER
GROUP BY
DATE( CREATE TIME ) A
LEFT JOIN ( SELECT COUNT( ORDER_ID ) 每日下单数,
COUNT( DINSTINCT ( USER_ID ) ) 每日下单用户数 FROM ORDER GROUP BY DATE( CREATE TIME ) ) B
ON A.DATE( CREATE TIME ) = B.DATE( CREATE TIME )
