SELECT
   a.id,
   (SELECT MAX(id), dateiname FROM photos WHERE user_id = a.id),
   a.name
FROM defaultusers a
WHERE
   a.status = 'N'

ORDER BY a.lastlogin DESC
LIMIT 0,10