title: mysql query user stay in same city and same country
body: <p>I have a table users thas has the following fields</p>
  
  <pre><code>id, name, city id, country id 
  </code></pre>
  
  <p>How can I select users who are in the same city and same country?</p>
  
  <p><strong>Example</strong></p>
  
  <pre><code>id   name cityid countryid
  1    ram   1       2
  2    sam   5       2
  3    bil   1       2
  4    roy   4       6
  5    bin   5       2
  7    abu   7       5
  </code></pre>
  
  <p>What is the <code>MySQL</code> query so I can fetch only user id 1 and 3 having same city id 1 and country id 2
  and user id 2 and 5 for same city if 5 and country id 2.</p>