更改代码如下

$selectTicket = "select ticketID from ticketusermapping where userID=$userID and distanceofticket <=$miles;";
    $rsTicket = mysqli_query($link, $selectTicket);
    $numOfTicket = mysqli_num_rows($rsTicket);
    if ($numOfTicket > 0) {
        $allRowData = array();
        while ($row = mysqli_fetch_assoc($rsTicket)) {
            $allRowData[] = $row['ticketID'];
        }
        $QueryStr = "SELECT * FROM ticket WHERE ticketID IN (" . implode(',', $allRowData) . ")";

$ids = array_column( $allRowData, 'ticketID'); //this will take all ids as new array
 $QueryStr = "SELECT * FROM ticket WHERE ticketID IN (".implode(',', $ids).")";

您应该使用 JOIN 为此：

$query = "
  SELECT t.* 
  FROM ticket t 
  JOIN ticketusermapping tum 
    ON t.ticketID = tum.ticketID
   AND tum.userID = '$userID'
   AND tum.distanceofticket <= '$miles'
";

$stmt = mysqli_query($link, $query);

$numOfTickets = mysqli_num_rows($stmt);

while($row = mysqli_fetch_assoc($stmt)){
    var_dump($row); // here will be the ticket data
}