title: Matching multiple tables get role name
body: <p>I am trying to match Project.user_Id to User.id and User.role_Id to Role.id.<br/>
  From here get all the Role.name where Project.Assignment_id = 1.</p>
  
  <pre><code>Table1 - Project
  id
  assignment_Id
  user_Id
  
  Table2 - User
  id 
  role_Id
  
  Table3 - Role
  id
  name
  </code></pre>
  
  <p>What is the laravel eloquent way of writing?</p>
  
  <pre><code>SELECT *
  FROM Project, User, Role
  INNER JOIN Project.user_Id ON User.id
  INNER JOIN User.role_Id ON Role.id
  WHERE Project.Assignment_id = 1;
  </code></pre>
  
  <p>I will the store it in a variable and pass it to view. <br/>$getRoleNames = 'DB:Table ...'<br/>->get()</p>
  
  <pre><code>@foreach($getRoleNames as $getRoleName)
  {{ $getRoleName -&gt;name }}
  @endforeach
  </code></pre>
  
  <p>Here I achieve getting all role name from Project.Assignment_id = 1</p>