thinkphp group分组示例

 1 $this->where(['store_id' => self::$storeId,'status' => 10,'is_delete' => 0])
 2             ->field("user_id,imagetype")
 3               ->field("GROUP_CONCAT(
 4                          CONCAT(file_path)
 5                         separator',') AS imglist")
 6             ->group('user_id')
 7             ->order('create_time desc')
 8             ->paginate(10)
 9             ->each(function($item,$key){
10                 $item['imglist'] = $this->getImageUrl($item['imglist']);
11             });

 

posted @ 2023-02-27 11:25  黑色低调  阅读(20)  评论(0)    收藏  举报