Use an "update" statement with a correlated sub-query, e.g.

update geo_m_count g
set person_count = (
   select count(*)
   from cases c
   where <as per OP>
)
[download]

No Perl required.