如何在连接两个表获取数据时获得不同的单列值

Question

$data['establishments2'] = Establishments::Join("establishment_categories",'establishment_categories.establishment_id','=','establishments.id')->where('establishments.city','LIKE',$location)->where('establishments.status',0)->whereIn('establishment_id',array($est_data))->get(array('establishments.*'));

这是控制器状态。

我有两个表，在表1中，我将id与表2进行匹配，然后从表1中获取数据，在表2中，我在表1具有多个相同id的值。我只想一次获得表1值的数据，但由于我在表2中有多个相同id的数据，数据重复了多次，有人能告诉我如何在具有相同id的单个值或多个值的表2中只获得一次数据吗…谢谢

Answer 1

您可以通过选择所需的字段名称来完成此操作相反，从表机构获取所有字段

$data['establishments2'] = Establishments::Join("establishment_categories",'establishment_categories.establishment_id','=','establishments.id')->where('establishments.city','LIKE',$location)->where('establishments.status',0)->whereIn('establishment_id',array($est_data))->get(array('establishments.*'));

您可以从等表格机构中选择特定字段

$data['establishments2'] = Establishments::Join("establishment_categories",'establishment_categories.establishment_id','=','establishments.id')->where('establishments.city','LIKE',$location)->where('establishments.status',0)->whereIn('establishment_id',array($est_data))->get('establishments.fieldName');

或者你也可以做

$data['establishments2'] = `Establishments::Join("establishment_categories",'establishment_categories.establishment_id','=','establishments.id')->where('establishments.city','LIKE',$location)->where('establishments.status',0)->whereIn('establishment_id',array($est_data))->select('establishments.fieldName')->get();`