SELECT users.name, fotos.id, fotos.name AS aktuellstes_foto FROM users
  LEFT JOIN fotos ON
     fotos.userid = users.name AND fotos.id = max(fotos.id)
ORDER BY users.datum DESC
LIMIT 3,40