title: Laravel Join Two Table, Get NULL ROW if Record not found
body: <p>Let's consider two tables, "users" and "data"</p>
  
  <p>"users" table data (total number of rows -> 2)-></p>
  
  <pre><code>user_id      name         email
  1            Test      test@test.com
  2            Try       try@try.com
  </code></pre>
  
  <p>"data" table data (total number of rows -> 1)-> </p>
  
  <pre><code>data_id     user_id    json_field
  1               1           {}
  </code></pre>
  
  <p>Using Laravel Join </p>
  
  <pre><code>DB::tabe("users")-&gt;join("data" , "users.user_id" , "=" , "data.user_id")-&gt;get();
  </code></pre>
  
  <p>The about query returns only one row, which is </p>
  
  <pre><code>user_id      name      email            data_id    json_fied
    1          Test    test@test.com         1          {}
  </code></pre>
  
  <p>But, I want to get the result of two rows like below:</p>
  
  <pre><code>user_id      name      email            data_id    json_fied
    1          Test    test@test.com         1          {}
    2          Try     try@try.com          NULL       NULL
  </code></pre>
  
  <p>Any idea? </p>