你应该试试这个。你觉得它会根据你的情况起作用吗

select a.Trans_rent as Single, b.Trans_rent as Group 
from table as a 
inner join table as b on a.city_from = b.city_from and a.city_to = b.city_to 
and b.single_or_group_id = 2 
where a.single_or_group_id = 1

你可以看到这个。希望对你有帮助。

<?php

$map_city = ['2'=>'Madina','3'=>'Makkah'];
$single_group = ['1'=>'Single','2'=>'Group'];

$data = [
    [
        'city_form' => 2,
        'city_to' => 3,
        'single_or_group_id' => 1,
        'rent' => 1000
    ],

    [
        'city_form' => 2,
        'city_to' => 3,
        'single_or_group_id' => 2,
        'rent' => 4000
    ],

];

?>

<table style="width:25%" border=1>

    <?php $is_first = true; ?>
    <?php foreach($data as $single){ ?>

    <?php if($is_first) { ?>
      <tr>
          <th colspan=2><?php echo $map_city[$single['city_form']] .'-'. $map_city[$single['city_to']];?></th>
      </tr>

      <tr>
         <?php foreach($data as $single){ ?>
             <td><?php echo $single_group[$single['single_or_group_id']];?></td>
         <?php } ?>
      </tr>

      <tr>
         <?php foreach($data as $single){ ?>
             <td><?php echo 'S.R '.$single['rent'];?></td>
         <?php } ?>
      </tr>

        <?php $is_first = false; } ?>

    <?php } ?>

</table>