title: Yii2 : How to write Mysql query to select records from two tables using left join
body: <p>I have two tables which i want to join... i.e. camps &amp; cities.
  I have write the query in PHP for this... but I want same query in Yii2 format... Please tell me how can i write this query in yii2...??</p>
  
  <p><strong>Here is my query :</strong></p>
  
  <pre><code>SELECT DISTINCT camps.city_id, camps.state_id, cities.city_name 
      from camps 
      LEFT JOIN cities
      ON cities.state_id = camps.state_id
      WHERE camps.state_id = 5
      AND camps.status = '1'
      ORDER BY cities.city_name ASC
  </code></pre>