Relationship

Question 1

One to one

Answer 1

Category ->foreign key of user & connet to user
public function user( ) {
return $this->hasOne(User::class , ‘id’,’user_id’ )
}

Question 2

Join with querybuilder

Answer 2

$categories = DB::table(‘categories’) ->join(‘users’,’categories.user_id’,’users.id’)->select(‘categories.* ‘ , ‘users.name’)