RLS policy for linking two tables in query

Table public.users {
  user_id, //links to table auth.user.id
  role,    //admin, super_admin, user
  email    //links to table auth.users.email
}

create policy admin_can_edit_policy 
    on public.users
    for update using ( 
        auth.uid() in ( 
            select role from public.users 
                where user_id = auth.uid() 
                and (
                    role = 'admin' 
                    or role = 'super_admin'
                )
                limit 1
        )
    );