Select last record for each foreign key that match primary key
<p>I am stuck in MySQL query. I have two tables one name is STUDENT and field names is (ID, FullName) where ID is PRIMARY KEY and another table is Student_FEE field is (ID, Student_ID, Date) here Student_ID is foreign key.
When i execute this query i get all the record of but i just want to select only that last row of each Student_ID not all here is image and query.
Remember I Just Need ID 5 and ID 9 </p>

<pre><code>SELECT Student_FEE.*
FROM Student_FEE
LEFT JOIN Student
ON Student_FEE.ID=Student.ID
</code></pre>

<p><a href="https://i.stack.imgur.com/6KZW2.png" rel="nofollow"><img src="https://i.stack.imgur.com/6KZW2.png" alt="enter image description here"></a></p>