title: Query builder - left join not working correctly
body: <p>I have two tables: posts and category. Some posts have assigned category, others not. I want to display posts with category names (it's not important they are joinde or not). I'm using leftJoin()</p>
  
  <pre><code>$fposts=DB::table('posts')-&gt;leftJoin('category', 'category.id', '=','posts.category_id')-&gt;get();
  return response()-&gt;view('main',['fposts'=&gt;$fposts]);enter code here
  </code></pre>
  
  <p>As result I receive only posts with assigned categories. What's wrong with my code?</p>