select members with the longest running absence streak
This is your "general idea" translated to SQL

select m.id, m.name, max(a.datetime_attended) as max_attened
from attendance as a
join members as m
  on m.id = a.member_id 
group by m.id, m.name
order by max_attened
limit 7