统计每周会员注册数量

#每周注册人数

 对每周注册会员数量一目了然！
 dateline:　　注册时间戳

 DATE_FORMAT(FROM_UNIXTIME(dateline),'%Y'):　　获取当前年份

weekofyear(FROM_UNIXTIME(dateline)) ：　　获取当前周数

weeknum:　　周数

按年份、月份分组并排序：
select DATE_FORMAT(FROM_UNIXTIME(dateline),'%Y') yearnum,weekofyear(FROM_UNIXTIME(dateline)) weeknum,COUNT(*) as '注册人数' from space us
group by yearnum,weeknum order by yearnum,weeknum;