gozap_api/Reports/Recharge/recharge_report.php

<?php
$rechargeSql = "SELECT *,
user.DEID,
recharge.CreatedAt AS RechargeCreatedAt,
recharge.UpdatedAt AS RechargeUpdatedAt 
FROM rechargehistory recharge
JOIN rider rider ON rider.RiderID=recharge.RiderID
JOIN user user ON user.UserID=rider.UserID 
WHERE recharge.IsActive='1' $rechargeSqlfilter";
$rechargeRes = mysqli_query($conn, $rechargeSql);
if ($rechargeRes->num_rows > 0) {
  $id = 0;
  foreach ($rechargeRes as $rechargerow) {
    $id++;
    $recharges = array_merge($recharges, array(array($id, $rechargerow['RechargeHistoryID'], $rechargerow['RiderID'], $rechargerow['DEID'], $rechargerow['TransactionID'], $rechargerow['PaymentTypeID'], $rechargerow['RechargeCreatedAt'], $rechargerow['RechargeUpdatedAt'])));
  }
}

$rechargeCountSql = "SELECT recharge.CreatedDate, count(recharge.RechargeHistoryID) AS ContData
FROM rechargehistory recharge
WHERE recharge.IsActive='1' $rechargeCountSqlfilter
GROUP BY recharge.CreatedDate";
$rechargeCountRes = mysqli_query($conn, $rechargeCountSql);
if ($rechargeCountRes->num_rows > 0) {
  $id = 0;
  foreach ($rechargeCountRes as $rechargeCountrow) {
    $id++;
    $rechargeCount = array_merge($rechargeCount, array(array($id, $rechargeCountrow['CreatedDate'], $rechargeCountrow['ContData'])));
  }
}