View difference between Paste ID: rrrzBDmZ and 0x05sfgS

 <?php
 include 'conn.php';
 $conn = getConn();
   if ($conn->connect_errno > 0) {
       die ('Unable to connect to database [' . $conn->connect_error . ']');
     }
-    $sql = "SELECT * FROM services,subservice";
+    $sql = "SELECT nama_service,id_service,group_concat(nama_subservice) nama_sub
-    if (!$result = $conn->query($sql)) {
+ FROM services
 left join subservice on subservice.id_service = services.id_service
 group by id_service,nama_service";
 $result = $conn->query($sql);
     if (!$result) {
         die ('There was an error running query[' . $conn->error . ']');
     }
 
 
 
 ?>
 
 <meta charset="utf-8">
   <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
   <title>Groedu &mdash; Konsultan Manajemen Pajak</title>
   <link rel="stylesheet" href="css/style.css">
 
 
   <div class="js-animsition animsition" id="site-wrap" data-animsition-in-class="fade-in" data-animsition-out-class="fade-out">
 
 
     <header class="templateux-navbar" role="banner">
 
       <div class="container"  data-aos="fade-down">
         <div class="row">
 
           <div class="col-3 templateux-logo">
              <a href="index.php"><img  src="images/Logo Digital Marketing.png" alt="Image" class="img-fluid"> </a>
             <!-- <a href="index.html" class="animsition-link">Groedu</a> -->
           </div>
           <nav class="col-20 site-nav">
             <button class="d-block d-md-none hamburger hamburger--spin templateux-toggle templateux-toggle-light ml-auto templateux-toggle-menu" data-toggle="collapse" data-target="#mobile-menu" aria-controls="mobile-menu" aria-expanded="false" aria-label="Toggle navigation">
               <span class="hamburger-box">
                 <span class="hamburger-inner"></span>
               </span>
             </button> <!-- .templateux-toggle -->
 
             <ul class="sf-menu templateux-menu d-none d-md-block">
               <li class="active">
                 <a href="index.php" class="animsition-link">Home</a>
               </li>
               <li><a href="about.php" class="animsition-link">About</a></li>
               <li>
-                  $service = $item['NAMA_SERVICE'];
+
-                  $subservice = $item['NAMA_SUBSERVICE'];
+                <ul>
-                  echo '<ul>
+
-                  <li><a href="#">'.$service.'</a>
+
-                      <ul>
+
-                      <li><a href="#">'.$subservice.'</a></li>
+                  $service = $item['nama_service'];
-                      </ul>
+                  $subservice = explode(",",$item['nama_sub']);
-                    </li>
+                  echo '<li><a href="#">'.$service.'</a>
-                  </ul>';
+                      <ul>';
                   echo '<li><a href="#">'.implode("</a><li><a href="#">',$subservice).'</a></li>';
                   echo '    </ul>
                     </li> ';
 
                 }
 
                 ?>
                  </ul>
               </li>
               <li><a href="blog.php" class="animsition-link">Special Offers</a></li>
               <li><a href="testimonials.php" class="animsition-link">Testimonials</a></li>
               <li><a href="contact.php" class="animsition-link">Contact</a></li>
               <li><a href="blog.php" class="animsition-link">Articles</a></li>
             </ul> <!-- .templateux-menu -->
 
           </nav> <!-- .site-nav -->
 
 
         </div> <!-- .row -->
       </div> <!-- .container -->
 
     </header> <!-- .templateux-navba -->
     </div> <!-- .js-animsition -->
     </div> <!-- .templateux-cover -->