Modify users data as an admin

This sql query will give you a list of users, and you can use the user_id to make changes depending on what you want to do, if you need to update data in two tables just run two different update queries. Is that helpful enough or do you need some other examples? I am assuming you're using custom data, I don't know if the fill() option in shield will update custom fileds? Not sure about that.

Code:

        $users = $this->db->table('users, auth_groups_users,auth_identities')
->where('users.id = auth_groups_users.user_id')
->where('users.id = auth_identities.user_id')
->where('auth_identities.type', 'email_password')
->select('
users.id,
users.username,
users.status,
auth_groups_users.group,
auth_identities.secret
            ')
->orderBy('users.username', 'ASC')
->get();
return $users;