title: Cakephp 2.x find query having DISTINCT and COUNT together on same field
body: <p><code>User</code> table structure.</p>
  
  <pre><code>+------+-------+
  |  id  | data  |
  +------+-------+
  |  1   |   a   |
  +------+-------+
  |  1   |   b   |
  +------+-------+
  |  2   |   c   |
  +------+-------+
  </code></pre>
  
  <p>Desired result.</p>
  
  <pre><code>+------+-------+
  |  id  | count |
  +------+-------+
  |  1   |   2   |
  +------+-------+
  |  2   |   1   |
  +------+-------+
  </code></pre>
  
  <p>I tried DISTINCT and COUNT in many ways but still not getting desired result. </p>
  
  <p>What i am trying </p>
  
  <pre><code>$this-&gt;User-&gt;find('all',array(
  'conditions'=&gt; array(),
  'fields' =&gt; array(
  'DISTINCT(User.id)',
  'COUNT(DISTINCT User.id) as count'
  )
  )
  );
  </code></pre>