mysql - 无法获取 laravel 中的关系数据

Question

这是我的任务

public function show($id)
    {
        $newproject = Newproject::find($id);
        $data = [

            'name' => $newproject->user->name
        ];

        return $data;
    }

新项目模型

public function user()
    {
        return $this->hasOne(User::class,'user_id' ,'id');
    }

总是报错

message: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'users.user_id' in 'where clause' (SQL: select * from `users` where `users`.`user_id` = 1 and `users`.`user_id` is not null limit 1)"
exception: "Illuminate\Database\QueryException"
file: "C:\xampp\htdocs\larastart\vendor\laravel\framework\src\Illuminate\Database\Connection.php"
line: 669

请帮助我解决我的问题。

Answer 1

查看关系one-to-one referenceforeign_key user_id 在 newprojects 表中，您需要像这样建立关系:

用户模型:

public function newproject()
{
   return $this->hasOne(Newproject::class,'user_id');
}

新项目模型:

public function user()
{
   return $this->belongsTo(User::class);
}