Join Bertingkat

<tbody>
      <?php
      $no=1;
      $kueri = 
      "SELECT * FROM tbl_transaksi_perbaikan 
      LEFT JOIN tbl_pelanggan ON tbl_transaksi_perbaikan.id_pelanggan=tbl_pelanggan.id_pelanggan
      LEFT JOIN tbl_kerusakan ON tbl_transaksi_perbaikan.id_kerusakan=tbl_kerusakan.id_kerusakan
      LEFT JOIN tbl_perbaikan ON tbl_transaksi_perbaikan.id_perbaikan=tbl_perbaikan.id_perbaikan
      LEFT JOIN detail_brg1 ON tbl_transaksi_perbaikan.id_detail_brg1=detail_brg1.id_detail_brg1
      LEFT JOIN detail_brg2 ON tbl_transaksi_perbaikan.id_detail_brg2=detail_brg2.id_detail_brg2
      LEFT JOIN detail_brg3 ON tbl_transaksi_perbaikan.id_detail_brg3=detail_brg3.id_detail_brg3
      ";
      $sql_brand=mysqli_query($koneksi, $kueri) or die (mysqli_error($koneksi));
      while($transperbaikan = mysqli_fetch_array($sql_brand)) { 
        ?>
        <tr>
          <td><?= $no; ?></td>
          <td class="aksi">
            <div class="btn-group">
              <button type="button" class="btn btn-social btn-flat btn-info btn-sm" data-toggle="dropdown"><i class='fa fa-arrow-circle-down'></i>Pilih</button>
              <ul class="dropdown-menu" role="menu">
                <li>
                  <a id="edit_transperbaikan" data-toggle="modal" data-target="#ubah_transperbaikan" 
                  data-id="<?php echo $transperbaikan['id_transaksi_perbaikan']; ?>"
                  data-waktu_masuk           ="<?php echo $transperbaikan['waktu_masuk']; ?>"
                  data-kode_transaksi        ="<?php echo $transperbaikan['kode_transaksi']; ?>"
                  data-id_pelanggan          ="<?php echo $transperbaikan['id_pelanggan']; ?>"
                  data-id_nm_tipe_perangkat  ="<?php echo $transperbaikan['id_nm_tipe_perangkat']; ?>"
                  data-id_kerusakan          ="<?php echo $transperbaikan['id_kerusakan']; ?>"
                  data-id_perbaikan          ="<?php echo $transperbaikan['id_perbaikan']; ?>"
                  data-id_detail_brg1        ="<?php echo $transperbaikan['id_detail_brg1']; ?>"
                  data-id_detail_brg2        ="<?php echo $transperbaikan['id_detail_brg2']; ?>"
                  data-id_detail_brg3        ="<?php echo $transperbaikan['id_detail_brg3']; ?>"
                  data-jml_brg               ="<?php echo $transperbaikan['jml_brg']; ?>"
                  class="btn btn-social btn-flat btn-block btn-sm"><i class="fa fa-edit"></i> Ubah Data</a>
                </li>
                <li>
                  <a href="transperbaikan_hapus.php?id=<?php echo $transperbaikan['id_transaksi_perbaikan']; ?>" class="btn btn-social btn-flat btn-block btn-sm" onclick="return confirm('Anda yakin akan menghapus data ini?')"><i class="fa fa-trash"></i> Hapus</a>
                </li>
              </ul>
            </div>
          </td>
          <td><?= ($transperbaikan['waktu_masuk']); ?></td>
          <td><?= ($transperbaikan['kode_transaksi']); ?></td>
          <td><?= ($transperbaikan['nama_user']); ?></td>
          <td>
            <?php 
            $sql1=mysqli_query($koneksi, "SELECT * FROM detail_brg1 
              JOIN tbl_nm_tipe_perangkat ON detail_brg1.id_nm_tipe_perangkat=tbl_nm_tipe_perangkat.id_nm_tipe_perangkat WHERE id_detail_brg1='$transperbaikan[id_detail_brg1]'") or die (mysqli_query($koneksi));
            while ($keode=mysqli_fetch_array($sql1)) { 
              ?>
              <?php 
                $sql2=mysqli_query($koneksi, "SELECT * FROM tbl_nm_tipe_perangkat 
                JOIN tbl_nm_perangkat ON tbl_nm_tipe_perangkat.id_nm_perangkat=tbl_nm_perangkat.id_nm_perangkat WHERE id_nm_tipe_perangkat='$keode[id_nm_tipe_perangkat]'") or die (mysqli_query($koneksi));
                while ($keode2=mysqli_fetch_array($sql2)) {
                echo $keode2['nama_perangkat'];
             } ?>

            <?php }
            ?>
          </td>
          <td>
            <?php 
            $sql_part=mysqli_query($koneksi, "SELECT * FROM detail_brg1 
              JOIN tbl_nm_tipe_perangkat ON detail_brg1.id_nm_tipe_perangkat=tbl_nm_tipe_perangkat.id_nm_tipe_perangkat WHERE id_detail_brg1='$transperbaikan[id_detail_brg1]'") or die (mysqli_query($koneksi));
            while ($data_tipe=mysqli_fetch_array($sql_part)) {
              echo $data_tipe['nama_perangkat_tipe'];
            } ?>
          </td>
          <td><?php echo ($transperbaikan['nm_kerusakan']); ?></td>
          <td><?php echo ($transperbaikan['nm_perbaikan']); ?></td>
          <td><?= ($transperbaikan['nm_brg1']); ?> </td>
          <td><?= ($transperbaikan['nm_brg2']); ?> </td>
          <td><?= ($transperbaikan['nm_brg3']); ?> </td>
          <td><?= ($transperbaikan['jml_brg']); ?> </td>
          <td>Rp. <?php echo number_format($transperbaikan['hrg_jual_brg1'],0,',','.'); ?></td>
          <td>Rp. <?php echo number_format($transperbaikan['hrg_pasang_brg1'],0,',','.'); ?></td>          
        </tr>
        <?php
        $no++; 
      }
      ?>
    </tbody>