sql 根据时间段 获取统计

$sql = "select sum(字段名) as num,FROM_UNIXTIME(时间字段名,'%Y-%m-%d') as time from {{表名}} group by 时间字段 order by id desc limit 0,15";
$arr = Yii::app()->表名->createCommand($sql)->queryAll();