eloquent 多对多关联模型的问题:请帮忙看看为什么取不到数据呢,检查了好久了,请指点一下!
...
use App\Models\Admin\Company;
...
class User extends Authenticatable
{
protected $table = 'users';
...
public function companies()
{
return $this->belongsToMany(Company::Class, 'user_company', 'user_id', 'company_id');
}
}
-----------------------------------------
...
use App\Models\User;
...
class Company extends Model
{
protected $table = 'companies';
...
public function users()
{
return $this->belongsToMany(User::Class, 'user_company', 'company_id', 'user_id');
}
}
---------------------------------------------------------------
$companies = $user->companies();
dd( $user->companies());
------------------------------------------------
id user_id company_id created_at updated_at
77 1 45 2019-08-26 10:55:07 2019-08-26 10:55:07
78 3 46 2019-08-26 10:55:07 2019-08-26 10:55:07
79 1 47 2019-08-26 10:55:24 2019-08-26 10:55:24
80 3 48 2019-08-26 10:55:24 2019-08-26 10:55:24
81 4 49 2019-08-26 10:55:24 2019-08-26 10:55:24
82 1 50 2019-08-26 10:55:36 2019-08-26 10:55:36
83 3 51 2019-08-26 10:55:36 2019-08-26 10:55:36
84 4 52 2019-08-26 10:55:36 2019-08-26 10:55:36
85 5 53 2019-08-26 10:55:36 2019-08-26 10:55:36
86 1 54 2019-08-26 10:55:48 2019-08-26 10:55:48
87 3 55 2019-08-26 10:55:48 2019-08-26 10:55:48
88 4 56 2019-08-26 10:55:48 2019-08-26 10:55:48
89 5 57 2019-08-26 10:55:48 2019-08-26 10:55:48
90 6 58 2019-08-26 10:55:48 2019-08-26 10:55:48
91 1 59 2019-08-26 10:56:06 2019-08-26 10:56:06
92 3 60 2019-08-26 10:56:06 2019-08-26 10:56:06
93 4 61 2019-08-26 10:56:06 2019-08-26 10:56:06
94 5 62 2019-08-26 10:56:06 2019-08-26 10:56:06
95 6 63 2019-08-26 10:56:06 2019-08-26 10:56:06
96 7 64 2019-08-26 10:56:06 2019-08-26 10:56:06
数据库中是有数据的,但是拿不出来,请大家帮忙看一下,是有哪里我没有注意到吗?
推荐文章: