สอบถามความรู้เรื่องการวนลูป ด้วยคำนำหน้า array แล้วมีข้อมูลจากฐานต่อท้ายครับ

<?php 
$serverName = "localhost";
	$userName = "sa";
	$userPassword = "sa";
	$dbName = "kpidb";
	$conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
	$sql = "SELECT * FROM test";
	$query = mysqli_query($conn,$sql);

$colors = array("primary", "success", "warning", "danger");

while($result=mysqli_fetch_array($query,MYSQLI_ASSOC))
{
   foreach ($colors as $value) {
   		echo $value." ".$result["test"]."<br>";
   } 
}
?>

$colors = array('R1'=>"primary",'R2'=> "success", 'R3'=>"warning", 'R4'=>"danger");

while($result=mysqli_fetch_array($query,MYSQLI_ASSOC))
{
     echo $colors[$result["test"]]." ".$result["test"]."<br>";
}