$adapter = $this->userTableGateway->getAdapter();

$sql = new Sql($adapter);

$select = $sql->select();
$select->from(['au' => 'auth_users']);
$select->join(['aur' => 'auth_users_roles'], 'au.id = aur.user_id', [], $select::JOIN_INNER);
$select->join(['ar' => 'auth_roles'], 'ar.id = aur.role_id', ['roles' => 'name'], $select::JOIN_INNER);

$statement = $sql->prepareStatementForSqlObject($select);
$result = $statement->execute();

if ($result instanceof ResultInterface && $result->isQueryResult()) {
    $resultSet = new HydratingResultSet(new ReflectionHydrator, new User());
    $resultSet->initialize($result);

    return $resultSet;
}
return [];

object(AdminUserModuleModelUser)[413]
    private 'id' => string '1'
    private 'name_first' => string 'Name1'
    private 'name_middle' => string 'Name2'
    private 'name_last' => string 'Name3'
    private 'email' => string 'admin@mail.ru'
    private 'password' => string '123456'
    private 'roles' => string 'Администратор'
    private 'updated_at' => null
    private 'created_at' => string '2018.03.06 10:03:33'
object(AdminUserModuleModelUser)[424]
    private 'id' => string '2'
    private 'name_first' => string 'Name100'
    private 'name_middle' => null
    private 'name_last' => null
    private 'email' => string 'manager@mail.ru'
    private 'password' => string '123456'
    private 'roles' => string 'Менеджер по продажам'
    private 'updated_at' => null
    private 'created_at' => string '2018.03.06 10:03:32'
object(AdminUserModuleModelUser)[425]
    private 'id' => string '1' (length=1)
    private 'name_first' => string 'Name1'
    private 'name_middle' => string 'Name2'
    private 'name_last' => string 'Name3'
    private 'email' => string 'admin@mail.ru'
    private 'password' => string '123456'
    private 'roles' => string 'Менеджер по продажам'
    private 'updated_at' => null
    private 'created_at' => string '2018.03.06 10:03:33'

object(AdminUserModuleModelUser)[413]
    private 'id' => string '1'
    private 'name_first' => string 'Name1'
    private 'name_middle' => string 'Name2'
    private 'name_last' => string 'Name3'
    private 'email' => string 'admin@mail.ru'
    private 'password' => string '123456'
    private 'roles' => array{
        object(AdminUserModuleModelRoles)[424]
            private 'id' => string '2'
            private 'name' => string 'Name1'
            private 'description' => null
        object(AdminUserModuleModelRoles)[424]
            private 'id' => string '3'
            private 'name' => string 'Name2'
            private 'description' => null
    }
    private 'updated_at' => null
    private 'created_at' => string '2018.03.06 10:03:33'
object(AdminUserModuleModelUser)[424]
    private 'id' => string '2'
    private 'name_first' => string 'Name100'
    private 'name_middle' => null
    private 'name_last' => null
    private 'email' => string 'manager@mail.ru'
    private 'password' => string '123456'
    private 'roles' => string 'Менеджер по продажам'
    private 'updated_at' => null
    private 'created_at' => string '2018.03.06 10:03:32'