[TYPO3-mvc] query for match two users of same usergroup

[Domi]

Hi Toke
> Tx_Extbase_Domain_Model_FrontendUser
>    - usergroup
>      - Tx_Extbase_Domain_Model_FrontendUsergroup:1
>      - Tx_Extbase_Domain_Model_FrontendUsergroup:2
>      ...
>
> using the array iterators you can create a query based on the
> user->getUsergroup()

Yes I know that I can iterate through all my emails and archive the 
values through PHP functions, but I would like to know if this task is 
possible with pure SQL statement to avoid heavy traffic. There might be 
thousands of mailentries and to iterate each entry and test the 
usergroup of each from / to user seems for me a bit unefficient.

Cheers Dominic