laravel get data from multiple tables with
$user = User::select("id", "name")
->with(['positions' => function ($query) {
$query->select('name');
}, 'profile' => function ($query) {
$query->select("user_id", "company_name");
}])->get();
In User model write many to many relation with user positions (designation)
public function positions()
{
return $this->belongsToMany(\App\Position::class, 'user_position', 'user_id', 'position_id')
->withPivot(['position_id', 'user_id']); //if you don't need pivot you can remove it
}
In user Model relation with profile table
public function profile()
{
return $this->hasOne(Profile::class, 'user_id', 'id');
}