<?php
$q = $modx->newQuery('modUser');
$q->innerJoin('modUserProfile', 'Profile');
$q->limit(0);
$q->select(array(
"Profile.*",
"modUser.*",
));
$s = $q->prepare();
$s->execute();
while($row = $s->fetch(PDO::FETCH_ASSOC)){
print "<br>". $row['username']." ";
}