数据透视表没有附加 Laravel 关系

Question

这是我的代码：Project::find($project)->users()->attach($user)// $project = '1', $user = '2'和错误：SQLSTATE[HY000]: General error: 1364 Field 'user_id' doesn't have a default value (SQL: insert into `project_user` (`project_id`) values (2))如果您需要迁移Schema::create('project_user', function(Blueprint $table)    {        $table->increments('id');        $table->bigInteger('project_id')->unsigned();        $table->bigInteger('user_id')->unsigned();可能是什么问题呢？

Answer 1

看起来您的关系签名有误，请确保如下所示：

// In your Project model

public function users()

{

    return $this->belongsToMany('App\User', 'project_user', 'project_id', 'user_id');

}