query($sql1); while($row = mysqli_fetch_array($result1)) { $sql = "select * from `new_vendor` LEFT JOIN `vendor_product` ON `new_vendor`.`id` = `vendor_product`.`vendor_id` where `vendor_product`.`xlist`='" . $row['id'] . "' AND `new_vendor`.`status` > '2' AND vendor_product.series_product = 0"; $result = $conn->query($sql); $rowcount=mysqli_num_rows($result); if($rowcount != 0) { $subCatList .= '' . $row['name'] .' ('. $rowcount34 .')'; } } mysqli_close($conn); $data = ['success' => true, 'subCatList' => $subCatList]; header('Content-type: application/json'); echo json_encode($data); ?>