$zip = 12345; $c = $modx->newQuery('modUser'); $c->select($modx->getSelectColumns('modUser','modUser','',array('id','username'))); $c->innerJoin('modUserProfile','Profile'); $c->where(array( 'Profile.zip' => $zip, 'modUser.active' => true, )); $users = $modx->getCollection('modUser',$c); $list = array(); foreach ($users as $user) { $list[$user->get('id')] = $user->get('username'); }
$users = $modx->getCollectionGraph('modUser',array('Profile' => array()),$c);