ขอถามหน่อยครับ ผมต้องการดึงค่าจาก mysql 2 ฟิลด์ มาแสดงในฟิลล์ที่ 2 ทำยังใงครับ

$mysqli = new mysqli('localhost', 'my_user', 'my_password', 'my_db'); //เชื่อมต่อ

$sql5 = "SELECT `Dur_ID`,`Dur_Ntotal` FROM `durable_number` WHERE  ..."; //คำสั่ง

$resule = $mysqli->query($sql5); //query

foreach($resule as $key -> $val){ //loop ออก

echo $val['Dur_ID'].$val['Dur_Ntotal']; //แสดงผล

}

$sql6 = "INSERT INTO durable_number (Dur_ID,Dur_Ntotal,Dur_Status) VALUES ( '$txtDur_ID','$resultDur_Ntotal','A')";
		$query6 = mysqli_query($conn,$sql6);
$id=$conn->insert_id;
$conn->query('update durable set Dur_Ntotal = concat( Dur_Number, Dur_ID) where Dur_Number='.$id);

$sql4 = "UPDATE durable SET Dur_Total='$resultDur_Total'  WHERE  Dur_ID = '$txtDur_ID' ";
		$query4 = mysqli_query($conn,$sql4);
		$i =1;
		for($i;$i<=$txtDur_Total;$i++){
		//update Dur_Total in durable
		$sql5 = "SELECT Dur_ID  FROM durable_number  WHERE  Dur_ID = '$txtDur_ID' ORDER BY Dur_Ntotal DESC LIMIT 1";
		$query5 = mysqli_query($conn,$sql5);
		$result5 = mysqli_fetch_array($query5,MYSQLI_ASSOC);

		//$resultDur_Ntotal= intval($result5["Ntotal"]);
		//$resultDur_Ntotal = $resultDur_Ntotal+1;
		$myText = (string)$result5["Dur_ID"];
		$result = $myText.$i;

		//echo $result;
		
		$sql6 = "INSERT INTO  durable_number  (Dur_ID,Dur_Ntotal,Dur_Status) VALUES ( '$txtDur_ID','$result','A')";
		$query6 = mysqli_query($conn,$sql6);

INSERT INTO table (Dur_ID, Dur_Ntotal)
SELECT '$txtDur_ID', CONCAT('$txtDur_ID', IFNULL((SELECT MAX(RIGHT(Dur_Ntotal, LENGTH(Dur_Ntotal) - LENGTH(Dur_ID))) + 1 
FROM table
WHERE Dur_ID = '$txtDur_ID'), 1))