public static function getProfileGroup($id)
{
return (array) BackendModel::getContainer()->get('database')->getRecord('SELECT gr.id, gr.profile_id, g.id AS group_id, g.name, UNIX_TIMESTAMP(gr.expires_on) AS expires_on
FROM profiles_groups_rights AS gr
INNER JOIN profiles_groups AS g ON g.id = gr.group_id
WHERE gr.id = ?', (int) $id);
}