SELECT
    SQL_CALC_FOUND_ROWS
    a.id,
    b.id AS photo_id

FROM defaultusers a

LEFT JOIN photos b ON
    b.user_id = a.id
WHERE
    a.status = 'N'
    
GROUP BY a.id
ORDER BY a.lastlogin DESC
LIMIT 0,20;