title: Laravel join query using Laravel eloquent
body: <p>i have two tables 'users' and 'projects'</p>
  
  <p>Table users</p>
  
  <pre><code>-----------------------------------
  user_id | name | email | password |
  -----------------------------------
     1    |name1 |email1 | password1|
  -----------------------------------
     2    |name2 |email2 | password2|
  </code></pre>
  
  <p>Table projects</p>
  
  <pre><code> project_id  |user_id | name          | 
   --------------------------------------
      1        |   1    | project_name1 |
   -----------------------------------
      2        |   1    | project_name2 |
  </code></pre>
  
  <p>There is no relation between these two tables but user_id in projects are the id from user table. </p>
  
  <p>Normal Query</p>
  
  <p>SELECT a.user_id,a.name AS username,b.name AS project_name FROM users a LEFT JOIN projects b ON a.user_id=b.user_id;</p>
  
  <p>I want the same query execution in laravel eloquent.</p>
  
  <p>Have searched in google got some idea about "with" function but not able to get the output.</p>
  
  <p>Thanks. </p>