[TYPO3-dev] Getting members of backend group

[Patrick Rodacker]

Hi devs,

the column usergroup (varchar) holds a csv of all assigned backend group
ids. What is the best approach to get the entries, if I want to get all
users of a certain group?

For now I am using

$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', 'be_users', "pid=0
AND usergroup LIKE '%".intval($id)."%'
".t3lib_BEfunc::deleteClause('be_users'));

which works for me, but is not a really good solution in my opinion.

Is there any existing method I can use or another way to handle the user
group relations in a clean way?

Thanks and regards
Patrick