title: How to retrieve multiple relations with multiple tables in laravel eloquent
body: <p>I'm using Laravel 5.8 to build a babysitting site. I have 4 tables with different relationships as below:</p>
  
  <p><a href="https://jaleesa.app/images/StackOverFlow_01_01tabels.png" rel="nofollow noreferrer">please see this image</a></p>
  
  <p>The relationships are:</p>
  
  <pre><code>Babysitter-&gt;hasMany(session)
  Sessions-&gt;hasOne(Review)
  Sessions-&gt;hasOne(Kids)
  Sessions-&gt;hasOne(Babysitter)
  Sessions-&gt;hasOne(Parent)
  </code></pre>
  
  <p>I want to achieve 2 things:</p>
  
  <p><strong>First one</strong></p>
  
  <p>I want to show this result when listing all babysitters. I'm showing this information for each babysitter:</p>
  
  <p><a href="https://jaleesa.app/images/StackOverFlow_01_02sitteroverall.png" rel="nofollow noreferrer">plsease see this image</a></p>
  
  <p>See here what I couldn't achieve</p>
  
  <p><a href="https://jaleesa.app/images/StackOverFlow_01_04sitteroverall.png" rel="nofollow noreferrer">plsease see this image</a></p>
  
  <p>This is my code</p>
  
  <pre><code>Sitters::where('Status', 'active')-&gt;where('Verified', 1)-&gt;get();
  </code></pre>
  
  <p><strong>Second one</strong></p>
  
  <p>Also, I've tried to show kids name with parent review as shown here:</p>
  
  <p><a href="https://jaleesa.app/images/StackOverFlow_01_03sitterReview.png" rel="nofollow noreferrer">plsease see this image</a></p>
  
  <p>This is what i'm using</p>
  
  <pre><code>Sessions::select('Reviews.*', 'Sessions.Parent_id')-&gt;join('Reviews', 'Reviews.Session_id', '=', 'Sessions.id')-&gt;with('owner')-&gt;where('Trainer_id', session('user')-&gt;Id)-&gt;where('Status', '=', 'complete')-&gt;with('owner')-&gt;orderBy('Sessions.id', 'DESC')-&gt;get();
  </code></pre>
  
  <p>Here is <code>Session.php</code> Model</p>
  
  <pre><code>public function owner(){
      return $this-&gt;belongsTo('App\Models\Parents', 'Parent_id');
  }
  </code></pre>