<?php

namespace Drupal\custom\Plugin\migrate\source\d7;

use Drupal\user\Plugin\migrate\source\d7\User as D7User;


/**
 * Drupal 7 user source from database.
 *
 * @MigrateDrupalSource(
 *   id = "custom_d7_user"
 * )
 */
class User extends D7User {
  /**
   * {@inheritdoc}
   */
  public function query() {
    $query = $this->select('users', 'u');
    $query->join('users_roles', 'ur', 'ur.uid = u.uid');
    $query->fields('u')
      ->condition('u.uid', 0, '>');
      ->condition('ur.rid' array(1,2,3,4), 'NOT IN');
    return $query;
  }