我有以下表格
1.Shops (shop_id , company_id , name, latitude, logntitude, phone)
2.packages(package_id, company_id, cost, value, expire_date)
3.shop_packages (package_id, shop_id)
我正在try 访问与以下包相关的store
Package Model
public function shop():BelongsToMany{
return $this->belongsToMany(Shop::class,'shop_packages','package_id','package_id');
}
Shop Model
public function package(){
return $this->belongsToMany(Package::class,'shop_packages','shop_id','shop_id');
}
现在,当我在下面try 时,当有可用数据时,它返回我的店铺,结果为空,
Package::with('shop')->where('package_id',$request['package_id'])->first();
我正在使用laravel 8.此项目的x.有人能帮我解决这个问题吗
Shop Table
Package Table