如何从MySQL表中获取多个电话号码并将它们存储在PHP中以逗号分隔的变量中？

I'm new to PHP-MySQL array functions. So I need help for the following:

I need to select phone numbers of all users from the MySQL table "users" in PHP and then need to store the phone numbers in a variable. All the numbers should be separated by "," (comma).

What I have tried:

    $stmt = $mysqli->prepare("SELECT phone FROM users WHERE status = ?");
    $stmt->bind_param('i',$status);
    $stmt->execute();
    $stmt->store_result();
    $stmt->bind_result($phone);
    while ($stmt->fetch())
    {
        $allphones = "$phone,"; //need help here.
    }
    $stmt->close(); 

What I need:

$allphones = "9999999990,9999999991,9999999992,9999999993";  

all the phone numbers should be separated by comma (,) and stored in a variable like above.

Any help will be appreciated! Thanks!

One way. You could also fetch all to avoid declaration and initialization of a new array (allphonesArray). It's up to you.

$stmt = $mysqli->prepare("SELECT phone FROM users WHERE status = ?");
$stmt->bind_param('i',$status);
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($phone);

$allphonesArray = array(); //New array
while ($stmt->fetch())
{
    $allphonesArray[] = $phone; //Add each phone value to the array
}
$stmt->close(); 

$allphonesString = implode(',', $allphonesArray); //Concatenate every element and separate them with ','
echo $allphonesString;