title: Subqueries in Cakephp 3.0
body: <p>How can I Convert Mysql Query :</p>
  
  <pre><code>SELECT * , (
  
  SELECT COUNT( * ) 
  FROM articles
  WHERE  `user_id` =1
  ) AS total_count
  FROM articles
  WHERE  `user_id` =1
  GROUP BY user_id
  </code></pre>
  
  <p>into cakephp subquery?</p>
  
  <p>I have tried this,</p>
  
  <pre><code>$articlescount = $this-&gt;Articles-&gt;find('all')-&gt;where(['user_id' =&gt; 1])-&gt;count();
  print_r($articlescount);
  </code></pre>
  
  <p>Which returns me only no of count.</p>