基于thinkphp下编程
group_concat函数详解_group_concat()_小米粥i的博客-CSDN博客
$yesterday = date('Y-m-d', strtotime('-1 day'));
// 数据库表主要的三个字段是:name,price,time
$result= Db::table('fa_douyin_order')
->where('time',$yesterday)
->field('GROUP_CONCAT(name SEPARATOR ", ") as names_concat,GROUP_CONCAT(price SEPARATOR ", ") as price_concat,time')
->group('time')
->select();
return \json($result);