php - Laravel hasManyThrough - 保存不起作用

Question

table groups
(
    id int auto_increment primary key,
    ...
);

table users
(
    id int auto_increment primary key,
    ...
);

table user_groups
(
    id int auto_increment primary key,
    user_id int not null,
    group_id int not null,
    ...
);

在我的组模型中，我有一个 hasManyThrough 关系来通过 user_groups 链接表访问用户。

class Group
{
    function users()
    {
        return $this->hasManyThrough('\App\Models\User', '\App\Models\UserGroup', 'group_id', 'id', 'id', 'user_id');
    }
}

在我的 Controller 中:

$user = User::find(2);
$group->users[] = $user;
$group->save();

所以 $group->users 是一个集合，我可以添加我的用户，但它没有保存。

如何在hasManyThrough 关系上添加记录？

Answer 1

当然你可以这样做:

// Find an existing User record
$user = App\User::find(2);

// Creates a new group instance 
$group = new App\group(['name' => 'shokry']);

// effectively sets $group->User_id to 2 then saves the instance to the DB
$user->groups()->save($group);

模型

class User extends Model
{
  public function groups()
  {
    return $this->hasMany(App\Group::class);
  }
}

class Group extends Model
{
  public function user()
  {
    return $this->belongsTo(App\User::class);
  }
}