$lists = Db::name('10086_sms')
->field("count(*) as count,FROM_UNIXTIME(addtime,'%Y - %m') as months")
->group('months')
->select();
通过时间戳来统计,输出就是总数和月份
$lists = Db::name('10086_sms')
->field("count(*) as count,FROM_UNIXTIME(addtime,'%Y - %m') as months")
->group('months')
->select();
通过时间戳来统计,输出就是总数和月份