Custom SQL query on wp_users with the addition of wp_usermeta

I’d simply go for WP_User_Query for this:

$args = [
  'meta_key'   => 'is_registered',
  'meta_value' => 'Yes',
  'fields'     => 'ID',
];

$user_query = new WP_User_Query($args);