<ul class="grade-list">
<strong>English:</strong>
<?php
// select all records from grades_subjects and join students and users to get user who's parent is logged in and where subject name equals English
$sql = "SELECT *  FROM grades_subjects INNER JOIN students ON students.student_name = grades_subjects.student_name  INNER JOIN users ON students.student_name = users.student_name WHERE user_id = '$id' AND subject_name = 'English'";

$result = $connect->query($sql);

if ($result->num_rows > 0) {
 // output data of each row
$i = 0;
    while($row = $result->fetch_assoc()) {
 $i++;
 echo '<li>';
$english_grade = $row['grade_name'];
echo $english_grade;
echo '</li>';
    }
} else {
    echo "0 results";
}
?>
</ul>