ปรึกษาเรื่องคำสั่ง merge sql หรือมีวิธีไหนแนะนำหน่อยค่ะ ดึงข้อมูล 2ตาราง ตัวอย่าง

$old_type='';
while($row = $result->fetch_object())
{
  if($old_type==$row->Type_name){
     $output .= ' 
<tr>
<td></td>	
<td></td>	
<td>'.$row->coler.'</td>	
<td>'.$row->lote.'</td>	
<td>'.$row->lct_name.'</td>	
<td>'.$row->name.'</td>	

</tr>
';
  }else{
      $output .= ' 
<tr>
<td>'.$row->Type_name.'</td>	
<td>'.$row->proname.'</td>	
<td>'.$row->coler.'</td>	
<td>'.$row->lote.'</td>	
<td>'.$row->lct_name.'</td>	
<td>'.$row->name.'</td>	

</tr>
';
      $old_type = $row->Type_name;
  }
}

<?php
$connect = mysqli_connect("localhost", "root", "", "test");
$connect->set_charset("utf8");
$output = '';
if(isset($_POST["query"]))
{
	$search = mysqli_real_escape_string($connect, $_POST["query"]);
	$query = "
		SELECT name, phone, Type_name, proname, color, lote FROM btest LEFT JOIN atest ON
 btest.pro_id=atest.pro_id	WHERE Type_name LIKE '%".$search."%'
	";
}
else
{
	$query = "
	SELECT name, phone, Type_name, proname, color, lote FROM btest LEFT JOIN atest ON
 btest.pro_id=atest.pro_id";
}
$result = mysqli_query($connect, $query);
if(mysqli_num_rows($result) > 0)
{
	$output .= '<div class="table-responsive">
					<table class="table table bordered">
		<tr>
		  <th>Type_name</th>	
		  <th>proname</th>	
		  <th>color</th>	
		  <th>lote</th>	
		  <th>name</th>
		  <th>phone</th>
						</tr>';
	while($row = mysqli_fetch_array($result))
	{
		$output .= '
			<tr>
		  <td>'.$row["Type_name"].'</td>	
		  <td>'.$row["proname"].'</td>	
		  <td>'.$row["color"].'</td>		
		  <td>'.$row["lote"].'</td>	
		  <td>'.$row["name"].'</td>	
		  <td>'.$row["phone"].'</td>		
			</tr>
		';
	}
	echo $output;
}
else
{
	echo 'Data Not Found';
}
?>

$result = mysqli_query($connect, $query) or die( $connect->error);

echo $query; exit; //เพิ่มบันทัดนี้เพื่อตรวจสอบ
$result = mysqli_query($connect, $query) or die( $connect->error);

<?php
require '_config.php';

// begins process step, do not display anything here except the error message. ----------------

$link = mysqli_connect($db_host, $db_username, $db_password);
if ($link === false) {
    throw new \Exception('Could not connect to the database: ' . mysqli_connect_error());
}

$db_selected = mysqli_select_db($link, $db_name);
if ($db_selected === false) {
    throw new \Exception('Could not select the database: ' . mysqli_error($link));
}

$link->set_charset('utf8');

$search = '';

$sql = 'SELECT *, `atest`.`pro_id` AS `pro_id` FROM `atest`';
if (!empty($search)) {
    $sql .= ' WHERE Type_name LIKE \'%' . mysqli_real_escape_string($search) . '%\'';
}
$result = mysqli_query($link, $sql);
unset($search, $sql);
if ($result === false) {
    throw new \Exception(mysqli_error($link));
}

// prepare the results into array for easily display later.
$resultList = [];
$i = 0;
while($row = mysqli_fetch_object($result)) {
    $resultList[$i] = $row;

    $sql2 = 'SELECT * FROM `btest` WHERE `btest`.`pro_id` = \'' . $row->pro_id . '\'';
    $result2 = mysqli_query($link, $sql2);
    $resultList[$i]->rowspan = '';
    if ($result2 !== false) {
        if ($result2->num_rows > 1) {
            $resultList[$i]->rowspan = ' rowspan="' . $result2->num_rows . '"';
        }
        while($row2 = mysqli_fetch_object($result2)) {
            if (!isset($resultList[$i]) || !is_object($resultList[$i])) {
                $resultList[$i] = new \stdClass();
            }
            foreach ($row2 as $key2 => $value2) {
                $resultList[$i]->{$key2} = $value2;
            }
            unset($key2, $value2);
            $i++;
        }
        $i--;
    }
    mysqli_free_result($result2);
    unset($result2, $row2, $sql2);

    $i++;
}

unset($i);

mysqli_free_result($result);
unset($result, $row);

$closed = mysqli_close($link);
unset($closed, $link);

// end process step. -------------------------------------
// begins display step. ----------------------------------

echo '<meta charset="utf-8">' . PHP_EOL;
echo '<style>table, th, td {border: 1px solid #ccc; border-collapse: collapse; text-align: left;}</style>' . PHP_EOL;

echo '<h3>for debug</h3>' . PHP_EOL;
echo '<pre>'.print_r($resultList, true).'</pre>' . PHP_EOL;

echo '<table style="width: 100%;">
    <tr>
        <th>Type_name</th>
        <th>proname</th>
        <th>color</th>
        <th>phone</th>
        <th>name</th>
    </tr>
';

foreach ($resultList as $row) {
    echo '    <tr>' . PHP_EOL;
    if (isset($row->Type_name)) {
        echo '        <td' . (isset($row->rowspan) ? $row->rowspan : '') . '>' . $row->Type_name . '</td>' . PHP_EOL;
        echo '        <td' . (isset($row->rowspan) ? $row->rowspan : '') . '>' . $row->proname . '</td>' . PHP_EOL;
        echo '        <td' . (isset($row->rowspan) ? $row->rowspan : '') . '>' . $row->color . '</td>' . PHP_EOL;
    }
	if (isset($row->phone)) {
		echo '        <td>' . $row->phone . '</td>' . PHP_EOL;
	} else {
		echo '        <td></td>' . PHP_EOL;
	}
	if (isset($row->name)) {
		echo '        <td>' . $row->name . '</td>' . PHP_EOL;
	} else {
		echo '        <td></td>' . PHP_EOL;
	}
    echo '    </tr>' . PHP_EOL;
}

unset($resultList, $row);

echo '</table>' . PHP_EOL;