ติดปัญหาค่ะ ภารกิจเดียวกัน แต่มีผู้รับผิดชอบหลายคน อยากให้แสดงแค่แถวเดียว ต้องทำอย่างไรค่ะ

$sql_Fmission="select mission.mission_id,mission.mission,mission.statuss,
officer.officer_id,officer.officer,
mission_officer.mission_id,mission_officer.officer_id
from mission inner join mission_officer on mission.mission_id=mission_officer.mission_id
inner join officer on mission_officer.officer_id=officer.officer_id
group by mission.mission_id order by mission.mission_id asc";

SELECT mission_officer.mission_id, mission.mission, mission.status,
   STUFF((SELECT ',' + officer.officer FROM officer FOR XML PATH('')), , 1, 1, '') AS officer
FROM mission_officer
INNER JOIN mission ON (mission_officer.mission_id = mission.mission_id)
INNER JOIN officer ON (mission_officer.officer_id = officer.officer_id)
GROUP BY mission_officer.mission_id, mission.mission, mission.status
ORDER BY mission_officer.mission_id ASC

SELECT MO1.mission_id, M1.mission, M1.status,
   STUFF((SELECT ',' + officer.officer 
      FROM mission_officer AS MO2
      INNER JOIN officer AS O2 ON (MO2.officer_id = O2.officer_id)
      WHERE MO2.mission_id = MO1.mission_id FOR XML PATH('')), 1, 1, '') AS officer
FROM mission_officer AS MO1
INNER JOIN mission AS M1 ON (MO1.mission_id = M1.mission_id)
INNER JOIN officer AS O1 ON (MO1.officer_id = O1.officer_id)
GROUP BY MO1.mission_id, M1.mission, M1.status
ORDER BY MO1.mission_id ASC

SELECT
    *,
    (
        SELECT GROUP_CONCAT(`officer`.`officer`) FROM  `mission_officer`
        JOIN `officer` USING (`officer_id`)
        WHERE `mission_officer`.`mission_id` = `mission`.`mission_id`
    ) AS `officers`
FROM `mission`
ORDER BY `mission`.`mission_id`

<td><? echo $rows_Fmission['officers']; ?></td>

SELECT MO1.mission_id, M1.mission, M1.status,
   STUFF((SELECT ',' + O2.officer 
      FROM mission_officer AS MO2
      INNER JOIN officer AS O2 ON (MO2.officer_id = O2.officer_id)
      WHERE MO2.mission_id = MO1.mission_id FOR XML PATH('')), 1, 1, '') AS officer
FROM mission_officer AS MO1
INNER JOIN mission AS M1 ON (MO1.mission_id = M1.mission_id)
INNER JOIN officer AS O1 ON (MO1.officer_id = O1.officer_id)
GROUP BY MO1.mission_id, M1.mission, M1.status
ORDER BY MO1.mission_id ASC

SELECT MO1.mission_id, M1.mission, M1.status,
   STUFF((SELECT ',' + O2.officer 
      FROM mission_officer AS MO2
      INNER JOIN officer AS O2 ON (MO2.officer_id = O2.officer_id)
      WHERE MO2.mission_id = MO1.mission_id FOR XML PATH('')), 1, 1, '') AS officer
FROM mission_officer AS MO1
INNER JOIN mission AS M1 ON (MO1.mission_id = M1.mission_id)
GROUP BY MO1.mission_id, M1.mission, M1.status
ORDER BY MO1.mission_id ASC

$sql_Fmission = "
SELECT
    *,
    (
        SELECT GROUP_CONCAT(`officer`.`officer` SEPARATOR '\\n') FROM  `mission_officer`
        JOIN `officer` USING (`officer_id`)
        WHERE `mission_officer`.`mission_id` = `mission`.`mission_id`
    ) AS `officers`
FROM `mission`
ORDER BY `mission`.`mission_id`
";

...
<tr bgcolor="#EAF1DD">
<td><? echo $rows_Fmission['mission_id']; ?></td>
<td><? echo $rows_Fmission['mission']; ?></td>
<td><? echo $rows_Fmission['statuss']; ?></td>
<td>
<ul>
<?php
// ตรวจว่ามีผู้ดูแลในรายการนี้หรือไม่
if (isset($rows_Fmission['officers'])) {
    // แยกชื่อด้วยการขึ้นบรรทัดใหม่ ( \n )จะได้ array ของชื่อ
    // เพื่อสามารถนำไปวนลูป แสดงผลแต่ละชื่อในรูปแบบที่ต้องการ
    $officers = explode("\n", $rows_Fmission['officers']);
        foreach ($officers as $officer) {
            ?>
            <li><?php echo $officer; ?></li>
            <?php
        }
} else { // ถ้ายังไม่มีให้แสดงอย่างอื่น
    ?>
    <li>ยังไม่มีผู้รับผิดชอบ</li>
    <?php
}
?>
</ul>
</td>
...