根据某张表的数据进行分组后获取最新数据

  根据某张表的数据进行分组后获取最新数据
  
    $count = A表::query()
        ->where('company_wechat_id', $wechatId)
        ->where('is_delete', 0)
        ->count();
    $sql = A表::query()
        ->where('company_wechat_id', $wechatId)
        ->where(function ($query) use ($customerIdArr, $type) {
            if ($type) { //type 0 查询所有 1 按标签查
                $query->whereIn('customer_id', $customerIdArr);
            }
        })
        ->where('is_delete', 0)
        ->orderBy('id', 'DESC')->limit($count);
    $list = A表::query()
        ->from(DB::raw('(' . $sql->toSql() . ') as a'))
        ->mergeBindings($sql->getQuery())
        ->where('company_wechat_id', $wechatId)
        ->where('is_delete', 0)
        ->groupBy(['customer_id'])
        ->select(['customer_id as id', 'user_id',
            DB::raw("(select B表.external_userid from B表 where
            wechat_customer.id=a.customer_id) as external_userid")
        ])
        ->get()
        ->toArray();