title: laravel get result from first table if second table did not match join condition
body: <p>I have a requirement where I need to get result from first table if the joined table where condition didn't satisfy.</p>
  
  <p>I have two table food and food_translation,in food_translation table food names where saved in different languages and default name in food table.</p>
  
  <p>if language condition didnt match in food_translation table,then need to get food default_name from food table</p>
  
  <pre><code>$food = DB::table('Program')
  -&gt;leftJoin('Meals', 'Program.meal_id', '=', 'Meals.meals_id')
  -&gt;leftJoin('Food', 'Meals.food_id', '=', 'Food.food_id')
  -&gt;leftJoin('food_translation', 'food_translation.food_id', '=', 'Food.food_id')
  -&gt;select('Food.food_id','Food.food_name','food_translation.food_ame','Food.default_name')
  -&gt;where('food_translation.locale', '=', 'ar')-&gt;get();
  </code></pre>