<?php
 
	 
	 include "config.php";
 
	$sql="SELECT category_parent_id,category_parent_name FROM categories GROUP BY category_parent_name ASC"; 
	$query=mysqli_query($connect,$sql);
 
	 
	$result=mysqli_num_row($query);
 
	if($result > 0){
 
	    while ($row=mysqli_fetch_object($query)){ 
	     
	        echo $row['category_parent_name'];  
	         
	        $sub=$row['category_parent_id']; 
	         
	        $sub_cat="SELECT category_name FROM categories WHERE category_parent_id='$sub' "; 
	        $query2=mysqli_query($connect,$sub_cat);
 
	        while ($row2=mysqli_fetch_object($query2)){ 
	         
	            echo $row2['category_name'];         
	        } 
	     
	    }
 
	}
 
	else { echo "no result";}
 
	ممكن حد يصلح الكود ده