static function MemberMembergroups(Member $member)
    {
        if (!$member->Exists())
        {
            return array();
        }
        $sql = Access::SqlBuilder();
        $tblMmg = MemberMembergroup::Schema()->Table();
        $tblMg = Membergroup::Schema()->Table();
        $join = $sql->Join($tblMmg);
        $joinCondition = $sql->Equals($tblMmg->Field('MemberGroup'), $tblMg->Field('ID'));
        $where = $sql->Equals($tblMmg->Field('Member'), $sql->Value($member->GetID()));
        $orderBy = $sql->OrderList($sql->OrderAsc($tblMg->Field('Name')));
        
        return Membergroup::Schema()->Fetch(false, $where, $orderBy, null, 0, null, $join, JoinType::Inner(), $joinCondition);
    }