title: Laravel Eloquent Get certain columns from nested tables using with()
body: <p>I'm trying to get table with nested inheritance and filtered for certain columns. And can't find ho to easy do it.</p>
  
  <p>I have table shop witch has many locations (and location has one city) and many actions</p>
  
  <p>I want to get all of it in once with Eloquent and filter for specific columns.</p>
  
  <p>this how i was filtering shop table but don't know how to filter tables locations and actions.</p>
  
  <pre><code>$this-&gt;shop-&gt;with('locations')-&gt;with('actions')-&gt;get(array('id','name','recommended','category_id'));
  </code></pre>
  
  <p>I need something like this:</p>
  
  <pre><code>$this-&gt;shop
  -&gt;with('locations',Location::with('city', City::get(array('id','name')))-&gt;get(array('id','name')))
  -&gt;with('actions', Action::get(array('id','name')))-&gt;get(array('id','name')););
  </code></pre>