Tp5按照日期合计查询出数据

$deviceId=$this->request->param('deviceId');
$date=$this->request->param('date',30);//
$end_time=time();
$begain_time=$end_time-$date*3600*24;
$option=[];
if($deviceId){
    $option['t.deviceId']=$deviceId;
}
if($date){
    $option['workDatetime']=['between',[$begain_time,$end_time]];
}
$deviceId_arr=Db::name('user_device')->where('user_id',$this->auth->id)->column('deviceId');
$option['t.deviceId']=['in',$deviceId_arr];
$arr['sum_sy']=Db::name('device_lists')
    ->alias('t')
    ->join('device_pl p','t.deviceId=p.deviceId')
    ->where($option)
    ->sum('p.sy');
$arr['sy']=Db::name('device_lists')
    ->alias('t')
    ->join('device_pl p','t.deviceId=p.deviceId')
    ->where($option)
    ->sum('p.sy');
$arr['list']=Db::name('device_lists')//此处是核心，用到了group和对日期格式化的操作
    ->alias('t')
    ->join('device_pl p','t.deviceId=p.deviceId')
    ->where($option)
    ->field('sum(p.sy) as sy,FROM_UNIXTIME(workDatetime,"%m-%d") as  workDatetime')
    ->group("DATE_FORMAT(FROM_UNIXTIME(workDatetime),'%Y-%m-%d')")
    ->select();
$this->success('成功',$arr);