require_once (dirname(dirname(dirname(dirname(dirname(dirname(__FILE__)))))).'/model/modx/processors/security/user/getlist.class.php');

class xtestGetUserListProcessor extends modUserGetListProcessor{
    public function prepareQueryBeforeCount(xPDOQuery $c) {
        $c->leftJoin('modUserProfile','Profile');
        $c->leftJoin('modUserGroupMember', 'UserGroupMembers');
        $c->leftJoin('modUserGroup', 'UserGroup', 'UserGroupMembers.user_group = UserGroup.id');
        return $c;
    }

    public function prepareQueryAfterCount(xPDOQuery $c) {
        $c->select($this->modx->getSelectColumns('modUser','modUser'));
        $c->select($this->modx->getSelectColumns('modUserProfile','Profile','',array('fullname','email','blocked')));
        $c->select($this->modx->getSelectColumns('modUserGroup','UserGroup','',array('name')));
        return $c;
    }

    public function prepareRow(xPDOObject $object){
        return array(
            'id' => $object->id,
            'username' => $object->username,
            'fullname' => $object->fullname,
            'email' => $object->email,
            'group' => $object->name,
        );
    }
}
return 'xtestGetUserListProcessor';    

$c->select($this->modx->getSelectColumns('modUser','modUser', '', array('id', 'username')));