MySQL table to array – PHP

$query = mysqli_query($mySQLiConnection, "SELECT * FROM table WHERE 1=1");

$array = array();

// look through query
while($row = mysqli_fetch_assoc($query)){
  // add each row returned into an array
  $array[] = $row;
  // OR just echo the data:
  echo $row['username']; // etc
}

print_r($array);