Row totals from another query

Hi, I’m sure this is straight forward but I can’t quite figure it out…

I have a simple bootstrap table showing results from one query (a list of group names).

I want to show the total number of participants from each group in parentheses next to each group name.

Participants are in another table - group_id is the foreign key.

2020-07-29_11-39-061142×383 28.1 KB

Thanks for any help.