dsfds.php

<?php

$id =1;
$q = $modx->newQuery('modUserGroupMember', array('member' => $id));
$q->leftJoin('modUserGroup', 'modUserGroup', 'modUserGroup.id = modUserGroupMember.user_group');
$q->select('modUserGroupMember.user_group,modUserGroup.name');
$q->sortby('modUserGroupMember.user_group');
if ($q->prepare() && $q->stmt->execute()) {
    $row = $q->stmt->fetch(PDO::FETCH_ASSOC);
    
}