Как вывести вместо ID городов их названия?

<?php
                $trip = get_trip();
                $sqlcitygo = mysqli_query($db, 'SELECT city.name FROM trip INNER JOIN city ON trip.city_go = city.id;')->fetch_assoc();
                $sqlcityin = mysqli_query($db, 'SELECT city.name FROM trip INNER JOIN city ON trip.id_city_in = city.id;')->fetch_assoc();
                foreach ($trip as $trip) :
                    ?>
                    <tr>
                        <th scope="row">
                            <p class="text-center lead"><?php echo $trip["id"] ?></p>
                        </th>
                        <td>
                            <p class="text-center lead"><?php echo $trip["time_go"] ?></p>
                        </td>
                        <td>
                            <p class="text-center lead"><?php echo $trip["time_in"] ?></p>
                        </td>
                        <td>
                            <p class="text-center lead"><?php echo $trip["distance"] ?></p>
                        </td>
                        <td>
                            <p class="text-center lead"><?php echo $sqlcitygo['name'] ?></p>
                        </td>
                        <td>
                            <p class="text-center lead"><?php echo $sqlcityin['name'] ?></p>
                        </td>
                        <td>
                            <p class="text-center lead"><?php echo $trip["periodicity"] ?></p>
                        </td>
                    </tr>
                <?php endforeach; ?>