SELECT pl.username, amount, pl1.date
FROM paylist pl1
JOIN (
  SELECT username, MAX( date ) AS date
  FROM paylist pl2
  GROUP BY username
) AS pl2 ON pl1.username = pl2.username
AND pl1.date = pl2.date