如果使用左连接的所有表中的一个列名相同，则打印列值

Question

How to echo any column value by using LEFT JOIN method where one column name is common in all the tables used in select query? Below in my code. I want to get 'app_id' value along with all the columns, but 'app_id' doesn't print anything. app_id column is available in all 4 tables used in this query. It prints all the rows that i want to show but app_id does not return any value.

<?php

session_start();

include('../../connect.php');

$date = strtotime("+1 day", time());
$cdate = strtotime("-7 day", time());
$finaldate = date('Y-m-d', $date);
$scdate = date('Y-m-d', $cdate);

//$sql = "SELECT * FROM tblapps WHERE journeydate >= '".$finaldate."' AND appstatus = 'On-Hold' AND process = 'yes'";

$sql = "SELECT * from tblapps
LEFT JOIN tblapps2 ON tblapps.app_id =   tblapps2.app_id
LEFT JOIN tblapps3 ON tblapps.app_id =  tblapps3.app_id
LEFT JOIN payments ON tblapps.app_id = payments.app_id
WHERE
tblapps.journeydate >= '$finaldate' AND tblapps.appstatus = 'On-Hold' AND tblapps.process = 'yes'";

$result = $connect->query($sql);
if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["app_id"]. " - Name: " . $row["firstname"]. " " . $row["journeydate"]. "<br>";
    }
} else {
    echo "0 results";
}
$conn->close();

?>