title: How to fetch specific columns from multiple tables in Laravel 5?
body: <p>I have 3 tables,</p>
  
  <ol>
  <li><p>Country:
  id,
  name</p></li>
  <li><p>Province:
  id,
  name,
  country_id</p></li>
  <li><p>City:
  id,
  name,
  province_id</p></li>
  </ol>
  
  <p>I have defined relationships in Model as follows,</p>
  
  <p>Country Model:</p>
  
  <pre><code>    public function Provinces()
          {
              return $this-&gt;hasMany('App\Province');
          }
  </code></pre>
  
  <p>Province Model:</p>
  
  <pre><code>        public function Country()
          {
              return $this-&gt;belongsTo('App\Country');
          }
  
          public function Cities()
          {
              return $this-&gt;hasMany('App\City');
          }
  </code></pre>
  
  <p>City Model:</p>
  
  <pre><code>    public function Province()
          {
              return $this-&gt;belongsTo('App\Province');
          }
  </code></pre>
  
  <p>I am using the below query, but it overwrites all the data with Country name.</p>
  
  <pre><code>    $city = DB::table('cities')
          -&gt;join('provinces', 'cities.province_id', '=', 'provinces.id')
          -&gt;join('countries', 'provinces.country_id', '=', 'countries.id')
          -&gt;select('cities.name','provinces.name','countries.name')
          -&gt;get();
  </code></pre>
  
  <p>I want to fetch a result of only City Name, Province Name, Country Name from these tables in laravel 5. Can you help me with that ?</p>