<?php
    $q = new Doctrine_Query();
    $q->select('u.*, COUNT(b.id) post_count')
      ->from('User u')
      ->leftjoin('u.Blog b')
      ->where('u.username = ?')
      ->groupby('u.id');
    $users = $q->execute(array($username));
    var_dump($users[0]->Blog[0]->post_count);

   // Unknown record property / related component 'post_count'.



    $q = new Doctrine_Query();
    $q->select('u.*, COUNT(b.id) post_count')
      ->from('User u')
      ->leftjoin('u.Blog b')
      ->groupby('u.id');
    $users = $q->execute(); //array($username));
    var_dump($users[0]->Blog[0]->post_count);

    // string(1) "2"