Hint:

foreach ($mysqli->query("select uid, name from users") as $row)
  print_r($row);

Not sure what you're trying to say, I'm aware as $row works.. 
This is a request for array destructuring to be supported too, like it is with PDO.

And what is the value of $row? What output do you see?

// mysqli
Array
(
    [uid] => 1
    [name] => Alpha
)

// PDO
Array
(
    [uid] => 1
    [0] => 1
    [name] => Alpha
    [1] => Alpha
)

RTFM

https://www.php.net/manual/en/mysqli-result.fetch-array.php

 resulttype

    This optional parameter is a constant indicating what type of array should be produced from the current row data. The possible values for this parameter are the constants MYSQLI_ASSOC, MYSQLI_NUM, or MYSQLI_BOTH.

    By using the MYSQLI_ASSOC constant this function will behave identically to the mysqli_fetch_assoc(), while MYSQLI_NUM will behave identically to the mysqli_fetch_row() function. The final option MYSQLI_BOTH will create a single array with the attributes of both.

As you can see, the value given through the iterator is an array that contains only associative string keys, not also numeric keys. It can be destructured - if you specify the keys.

...as ["uid" => $uid, "name" => $name]

I know.. hence my feature request (to support destructuring without keys).

Making the iterator return a different kind of array would be a breaking change for code that thinks the array is purely associative.

Is it really such a problem to destructure with keys?

I like code to be as simple as possible, having to repeat the code is less simple than is possible..

The inconsistency with PDO seems weird too.

If the potential incompatibility is a problem you could add a flag to the query function, indicating what the iterator should return.

Education center web are sharing latest news about education, classess, courses, stydy, learning, college education, govt job notification, etc. More info to visit:(https://educationcenterweb.com)github.com