If mysql use Group By, then only can select 1 row of record but u still want to select multiple record, then cannot use Group By. Solution :
Split Left Join query into two queries. Select first table then foreach loop select another table.
Example at Yxin project : controllers/member/Order.php

-------------------------------
Cannot echo for debuging on common.php because it will show error "array or variable is not defined". Solution use if(!empty($data)) : function getDirSponBonRate($user_id, $individul_package_size) { $got_record = 0; $data=$this->getSelectedOneRow("c.cart_id","tbl_cart c left join tbl_product_order o ON c.order_id = o.id","WHERE o.status = 3 AND c.pack_rank_upgrade = '2-Stars' AND c.user_id = '".$user_id."' "); if(!empty($data)) { $got_record = $data['cart_id']; echo $got_record; } }

-------------------------------
Cannot update records WHERE id In (12,32,47). Solution is either add quote for string or remove quote for number : // if $id is number but not string, then remove quote $many_bonus_id = "5#12#32" $multi_bonus_id = str_replace("#",",",$many_bonus_id ); $up_data1['breakaway_bonus_paid'] = 1; $this->common->updateRecord("tbl_ewallet",$up_data1, "id IN(" . $multi_bonus_id . ")"); //remove quote here //if $id is string, then add quote $many_bonus_id = "5#12#32" $multi_bonus_id = str_replace(("#","','",$many_bonus_id ); //add quote here $up_data1['breakaway_bonus_paid'] = 1; $this->common->updateRecord("tbl_ewallet",$up_data1, "id IN('" . $multi_bonus_id . "')");

----------------------------------
check carefully u are using getAllRec or getSelectedOneRow :
$childOfchildData = $this->getAllRec(
VS
$childOfchildData = $this->getSelectedOneRow(

If using getAllRec, then u need foreach loop to echo db record.
If using getSelectedOneRow, then no need foreach loop.

----------------------------------
What is correct syntax to add hour with php variable into date function in php? $newdate = "2021-10-03"; $fTime = 5; $hours = 9; echo date("Y-m-d H:i:s", strtotime ($newdate ." ". $fTime . ":00:00" . "+" . $hours . " hour"));
----------------------------------
Error : Cannot reinitialise DataTable.
Solution : Delete "datatable" class from div or table so that it won't auto apply datatable. Then manually apply datatable by jquery : $(document).ready(function () { $('#maintable').dataTable({ "bDestroy": true, destroy: true, "oSearch": {"sSearch": "<?=date("Y-m-d")?>"} }); })
----------------------------------