sqlacademia.php

<?php
$sqlNotificacao = "(SELECT n.mensagem FROM notificacao n WHERE n.id_aluno = a.id_aluno ORDER BY id_notificacao LIMIT 1 ) AS notificacao";
$sqlAcademia = "(SELECT academia.nome FROM academia WHERE academia.id_academia = a.id_academia) as academia";
$sqlselect = "SELECT a.*, $sqlAcademia, $sqlNotificacao FROM aluno a WHERE a.id_aluno =:id_aluno LIMIT 1";
$stmt = $db->prepare($sqlselect);
$stmt->bindParam("id_aluno", $id_aluno, PDO::PARAM_INT);
$stmt->execute();