查询的时候,将查询的时间转换为年月日
第二个field,将查询的日期转换为json放入optime字段
$ckdata = opmodel::alias('a')->join('opendaytime op', 'op.openday_id = a.id', 'left')
->where(['a.switch'=>1,'op.stime'=>['>=',$deta]])
// 将 GROUP_CONCAT(DATE_FORMAT(op.stime, "%Y-%m-%d"))转换为年月日
// ->field('a.*, GROUP_CONCAT(op.stime) as opstime, GROUP_CONCAT(op.etime) as opetime')
->field('a.*,GROUP_CONCAT(op.id) as opid,CONCAT("[", GROUP_CONCAT(JSON_OBJECT( "etime", DATE_FORMAT(op.etime, "%Y-%m-%d %H:%i:%s"),"stime", DATE_FORMAT(op.stime, "%Y-%m-%d %H:%i:%s"))), "]") as optime')
->group('a.id')
->select()->toArray();