laravel get data from multiple tables with

1$user = User::select("id", "name")
2        ->with(['positions' => function ($query) {
3            $query->select('name');
4        }, 'profile' => function ($query) {
5            $query->select("user_id", "company_name"); 
6        }])->get();
7
8
9In User model write many to many relation with user positions (designation)
10
11public function positions()
12{
13    return $this->belongsToMany(\App\Position::class, 'user_position', 'user_id', 'position_id')
14    ->withPivot(['position_id', 'user_id']); //if you don't need pivot you can remove it
15}
16
17In user Model relation with profile table
18public function profile()
19{
20    return $this->hasOne(Profile::class, 'user_id', 'id');
21}

1<?php
2
3namespace App\Models;
4
5use Illuminate\Database\Eloquent\Model;
6
7class Post extends Model
8{
9    /**
10     * Get the comments for the blog post.
11     */
12    public function comments()
13    {
14        return $this->hasMany(Comment::class);
15    }
16}

1use App\Models\Post;
2
3$comments = Post::find(1)->comments;
4
5foreach ($comments as $comment) {
6    //
7}