sub pages {
    my ($self) = @_;

    return $self->result_source->schema->resultset('RolePage')->search_rs(
        {   
            'username.username' => $self->username,
        },
        {   
            join => [
                {   
                    role => {user_roles => 'username'},
                },
                'page_name',
            ],
        }
    );
}