<?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";}
ممكن حد يصلح الكود ده