SELECT *
FROM makale INNER JOIN uyeler ON uyeler.id=makale.gonderen
WHERE id IN (
SELECT MAX(M.id) AS MAKALE_ID
FROM makale AS M
GROUP BY M.gonderen
ORDER BY M.id desc
)
ORDER BY uyeler.id desc