title: How could I create a sub-query in cakePHP?
body: <p>How could I create a sub-query in cakePHP with find method? For example:</p>
  
  <pre><code>SELECT *, (SELECT COUNT(*) FROM table2 WHERE table2.field1 = table1.id) AS count
  FROM table1
  WHERE table1.field1 = 'value'
  </code></pre>
  
  <p>!!! <strong>table2.field1 = table1.id</strong> !!!</p>