php - 关联数组的基本查询

Question

我如何查询这个？

图表正在处理此查询

$dataPoints = array();

$result = mysqli_query($conn, "SELECT * FROM service_booking GROUP BY service_id");

while($row = mysqli_fetch_array($result))
{        
    $point = array("label" => $row['service_id'] , "y" => $row['booking_id']);

    array_push($dataPoints, $point);        
}

但我希望“标签”$row['service_id']显示为['services']来自不同的父表。

  services (tbl1)                            service_booking (tbl2) 
 services || service_id                     service_id ||  booking id

标签： phpmysql

Answer 1

加入表格

SELECT b.*, s.services
FROM service_booking AS b
JOIN services AS s ON s.service_id = b.service_id