Doctrine issues

doctrine.php

<?php

$queryBuilder = $repository->createQueryBuilder('r')
  ->addSelect('eb.name AS brandName')
  ->addSelect('ea.name AS attributeSetName')
  ->addSelect('et.name AS entityTypeName')
  ->leftJoin('r.entityBrand', 'eb')
  ->leftJoin('r.eavAttributeSet', 'ea')
  ->leftJoin('r.entityType', 'et')
  ->addGroupBy('r.id')
  ->addOrderBy('r.id', 'DESC');
  
$data = $this->getQueryBuilder()->getQuery();
$data = $data->iterate();

foreach ($data as $row) {
  # do stuff with row
  # but only the firt $row will have data 
  # on the brandName, attributeSetName and
  # entityTypeName
}

example_output.json

{"createdAt":"13\\/12\\/13","sku":"foo","name":"test 3","attributeSetName":"Box","entityTypeName":"Kit","brandName": "Fubar"}
{"createdAt":"13\\/12\\/13","sku":"bar","name":"test 2","attributeSetName":" ","entityTypeName":" ","brandName":" "}
{"createdAt":"13\\/12\\/13","sku":"baz","name":"test 1","attributeSetName":" ","entityTypeName":" ","brandName":" "}