PHP, mySQL, Hämta data från 2 tabeller

    SELECT
        u1.*,
        g.text AS entry_text,
        g.date AS guestbook_date,
        u2.userID AS from_userID,
        u2.username AS from_username
    FROM
        users AS u1
    LEFT JOIN
        guestbook AS g ON u1.userID = g.toID
    LEFT JOIN
        users AS u2 ON g.userID = u2.userID
    WHERE
        u1.userID = :userId
    ORDER BY
        g.date DESC;

Showing rows 0 - 9 (10 total, Query took 0.0037 seconds.)
SELECT u1.*, g.text AS entry_text, g.date AS guestbook_date, u2.userID AS from_userID, u2.username AS from_username FROM users AS u1 LEFT JOIN guestbook AS g ON u1.userID = g.toID LEFT JOIN users AS u2 ON g.userID = u2.userID WHERE u1.userID = 15 ORDER BY g.date DESC;

userID username email text(entry_text) date(guestbook_date) toID userID(from_userID), username(from_username)
15 0 user15 user15@example.com This aint working1 2023-12-29 19:12:18 12 user12 
15 0 user15 user15@example.com This aint working1 2023-12-29 19:12:18 12 user12 
15 0 user15 user15@example.com This aint working1 2023-12-29 19:12:18 12 user12 
15 0 user15 user15@example.com This aint working1 2023-12-29 19:12:18 12 user12 
15 0 user15 user15@example.com This aint working1 2023-12-29 19:12:18 12 user12 
15 0 user15 user15@example.com This aint working1 2023-12-29 19:12:18 12 user12 
15 0 user15 user15@example.com This aint working1 2023-12-29 19:12:18 12 user12 
15 0 user15 user15@example.com This aint working1 2023-12-29 19:12:18 12 user12 
15 0 user15 user15@example.com This aint working1 2023-12-29 19:12:18 12 user12 
15 0 user15 user15@example.com This aint working1 2023-12-29 19:12:18 12 user12

<?php 
			$thisId = intval($_GET['userID']);
$sql = "
    SELECT
        u1.*,
        g.text AS entry_text,
        g.date AS guestbook_date,
        u2.userID AS from_userID,
        u2.username AS from_username
    FROM
        users AS u1
    LEFT JOIN
        guestbook AS g ON u1.userID = g.toID
    INNER JOIN
        users AS u2 ON u2.userID = g.userID 
    WHERE
        u1.userID = :userId
    ORDER BY
        g.date DESC;";

// Bind the parameters
$stmt = $db->prepare($sql);
$stmt->bindParam(':userId', $thisId, PDO::PARAM_INT);

// Execute the query
$stmt->execute();

			$userData = $db->fetchAssoc($stmt);
			if (empty($userData)) { 
				echo '<div class="column"><h2><span class="blue">PLAY.</span> Profil ej hittad</h2><div class="alert-error">Användaren du försökte hitta finns ej i vårat system...</div></div>';
			}
			else { 
				echo '<div class="column column-60">';
				echo '<h2><span class="radius"><span class="blue">PLAY.</span> Profil</span></h2>';
				echo '<div class="UserTitle">'.$userData['username'].' </div>';
				echo '<div class="Content">'; 
				echo '<div class="ImageBox"><img src="/img/users/1.png"></div>';
				echo '</div>';
				echo '</div>';
				echo '<div class="column column-40">'; 
				echo '<h2><span class="radius"><span class="blue">PLAY.</span> Gästbok</span></h2>';
				if (empty($userData['entry_text'])) {
						echo '<div class="alert-error">Tyvärr så har inte '.$userData['username'].' några gästboksinlägg :(</div>'; 
				}
				else { 
				echo '<table cellspacing="0" cellpadding="0" class="GuestBook">';
				 while ($row = $db->fetchAssoc($stmt)) {	
					var_dump($row);
					echo '<br><br>';
					echo '<tr><td width="60" valign="top"><div class="ImageBox"><img src="/img/users/1.png"></div></td><td valign="top"><div class="Title"><a href="/user/'.$row['from_userID'].'">'.$row['from_username'].'</a> - '.date('Y-m-d H:i', strtotime($row['guestbook_date'])).'</div><div class="Content">'.$row['entry_text'].'</div></td></tr>';
				}
				echo '</table>';
				echo '<div class="pagination"></div>';
				}
				if ($userID != $thisId) { echo '<form method="post"><input type="hidden" name="toID" value="'.$thisId.'"><textarea name="text" placeholder="Skriv ett meddelande..."></textarea><input type="submit" name="addGB" value="Skicka" class="btn-blue"></form>'; }
				echo '</div>';
			}
			$db->close();
		?>