title: How to perform this query in CakePHP?
body: <p>I have <code>Rooms</code> table and <code>Residents</code> table. every <code>Room</code> has different number of <code>Residents</code>, so my table is something like this:</p>
  
  <h3>Rooms</h3>
  
  <pre><code>+-------------------+
  | room_id | room_no |
  +-------------------+
  |   0001  |    5    |
  |   0002  |    6    |
  +-------------------+
  </code></pre>
  
  <h3>Residents</h3>
  
  <pre><code>+-------------------------------+
  | user_id | user_name | room_id |
  +-------------------------------+
  |  0123   |   John    |  0001   |
  |  0110   |   Gwen    |  0002   |
  |  0020   |   Kim     |  0002   |
  +-------------------------------+
  </code></pre>
  
  <p>So how to perform the query in <code>Controller</code> and then display it in <code>view</code> that would output like this?</p>
  
  <pre><code>Room 1 - Residents
  +----------+
  | 1 | John |
  +----------+
  
  Room 2 - Residents
  +----------+
  | 1 | Gwen |
  | 2 | Kim  |
  +----------+
  </code></pre>
  
  <p>Thanks in advance. </p>
  
  <h3>Note: I've already established proper associations my problem is on how to display it to the view as what I expected it to be.</h3>