$query = Drupal::database()->select('users_field_data', 'ufd');
  $query->fields('ufd', ['uid', 'name', 'mail', 'status']);
  $query->orderBy('ufd.status', 'Desc');

  $result = $query->execute()->fetchAll();

[
stdClass Object
(
    [uid] => 2
    [name] => Test 1
    [mail] => test@test1.com
    [status] => 1
)
stdClass Object
(
    [uid] => 3
    [name] => Test 3
    [mail] => test@test2.com
    [status] => 0
)
]

[status_key_1] => [
stdClass Object
(
    [uid] => 2
    [name] => Test 1
    [mail] => test@test1.com
    [status] => 1
)stdClass Object
(
    [uid] => 3
    [name] => Test 2
    [mail] => test@test2.com
    [status] => 1
)
]
[status_key_0] => [
stdClass Object
(
    [uid] => 4
    [name] => Test 4
    [mail] => test@test4.com
    [status] => 0
)stdClass Object
(
    [uid] => 5
    [name] => Test 5
    [mail] => test@test5.com
    [status] => 0
)
]