SELECT users.name, (SELECT MAX(id) FROM photos WHERE user_id = a.user_id) AS letztes_foto FROM users, photos WHERE photos.user_id = users.user_id GROUP BY users.name