yii1.1 怎么统计查询 [ 新手入门 ]

自己写sql:

$sql = 'select username,count(*) from posts group by username';
$ret = Yii::app()->db->createCommand($sql)->queryAll();
var_dump($ret);

controller:
$crite = new CDbCriteria;
$crite->compare('branchid',$this->branchId);
$count =PointsProduct::model()->count($crite);
$pages = new CPagination($count);
$pages->pageSize = 15;
$pages->applyLimit($crite);
$productList = PointsProduct::model()->with('stocks','brand')->findAll($crite);

view:

            $this->widget('CLinkPager',array(
                   'header'=>'',
                   'firstPageLabel' => '首页',
                   'lastPageLabel' => '末页',
                   'prevPageLabel' => '上一页',
                   'nextPageLabel' => '下一页',
                   'pages' => $pages,
                   'maxButtonCount'=>8,
                    'cssFile'=>false,
                    'htmlOptions' =>array("class"=>"pagination"),
                    'selectedPageCssClass'=>"active"
             )
             );

不知道是不是你需要的那个意思

$postList = Post::model()->findAll([

'select'=>"id,user_id,count(*) as post_num",
'condition' => "user_id={$user_id}",
'order'=>'id desc',

]);