php - 如何在数组中创建循环

Question

我有四张桌子：

要求：

ID	姓名	地位

休息日：

ID	请求ID

用户：

ID	姓名	软针	指定

指定：

ID	姓名

我正在使用datatable服务器端数据我正在尝试加入四个表都工作正常但我试图从dayoff表中获取天数的唯一问题可能是多条记录（行）并且我没有得到数据正确的

$empQuery = "select requests.id as reqid, requests.name, requests.status , users.softechid , users.name, users.designation ,designation.name AS l,designation.id, daysoff.requestid,daysoff.dayoff  FROM (((requests INNER JOIN users ON requests.name = users.name) INNER JOIN designation ON designation.id = users.designation) INNER JOIN daysoff ON requests.id = daysoff.requestid)   WHERE 1 ".$searchQuery."  order by ".$columnName." ".$columnSortOrder." limit ".$row.",".$rowperpage;
$empRecords = mysqli_query($connection, $empQuery);
$data = array();

$csv_var = '';

while ($row = mysqli_fetch_assoc($empRecords)) {
    $requesidfromrequest = $row['reqid'];
    $per_list[] = $row['dayoff'];

    $data[] = array(
            "id"=>$row['reqid'],
            "softechid"=>$row['softechid'],
            "name"=>$row['l'],
            "title"=>$row['name'],
            "daysoff" =>$csv_var,
            
    );
}

标签： phpajaxdatatable