SELECT
    SQL_CALC_FOUND_ROWS
    a.id,
    a.name,
    a.birthday,
    b.id

FROM defaultusers AS a

LEFT JOIN photos AS b ON
    b.id = (SELECT MAX(id) FROM photos WHERE user_id = a.id)

WHERE
    a.status = 'N' and
    a.sex = 'w'

ORDER BY a.lastlogin DESC
LIMIT 0, 10;