Group_concat in XPDO

gistfile1.txt

$query = $this->modx->newQuery('ClassName');
  $query->where(array(
    'project_id' => x
    ,'unit_id' => y
  ));

  $query->select(array(
    'ClassName.*',
    'array_node' => 'GROUP_CONCAT(DISTINCT colname_from_joined_table SEPARATOR " , ")'
  ));
  //example 2
  $query->select(array(
    'tag_ids' => 'GROUP_CONCAT(DISTINCT Tags.tag SEPARATOR ",")'
  ));

  $query->leftJoin('ClassName2','Alias');

  $query->prepare();

  if ($query->prepare() && $query->stmt->execute()) {
    $array = $query->stmt->fetchAll(PDO::FETCH_ASSOC); //view all returned data
  }

  $this->modx->log(xPDO::LOG_LEVEL_ERROR,'Label: ' . print_r($array, true));

  $output = $this->toJSON($array);