SELECT * FROM trip_stops
WHERE trip_id = ?
ORDER BY stop_order ASC;

foreach($stops as $s){
    echo $s['stop_order'].". ".$s['name']." - ".$s['status']."<br>";
}