Need help with recursive code

Hi,
I need some help with my code :
In my application, each user has a set of groups.
For now on, I can retrieve the groups of a user.
The problem, is that each group can also have a set of groups.
And the groups and the users are in the same table.
So I think I need something recursive ...
I need help with this.


Version which simply returns the direct groups of a user.

getGroups( objectId ) {

   Sql database : get the object

   Retrieve the groups of the object

   Return the groups

}


But need to have the indirect groups :


getGroups( objectId ) {

   Sql database : get the object

   Retrieve the groups of the object

   For each group : call getGroups again ?

   return ... ?

}


Code in Java which returns the groups a user :

public List getMemberGroups(IInfoStore iStore, int objectID) throws RetrieveGroupsException {
      List groups = new ArrayList();

      IInfoObjects usersAllProp =
            iStore.query("Select TOP 1* From CI_SYSTEMOBJECTS WHERE SI_ID=" + objectID);
      if (usersAllProp.size() == 0)
            return groups;
      else {
            IInfoObject userAllProp = (IInfoObject) usersAllProp.get(0);
            // Check that the object has the correct ProgID.
            String uProgID =
                  (String) userAllProp
                        .properties()
                        .getProperty(CePropertyID.SI_PROGID)
                        .getValue();
            if (uProgID.equals(CeProgID.USER)) {
                  Object[] memberGroups = ((IUser) userAllProp).getGroups().toArray();
                  for (int j = 0; j < memberGroups.length; j++) {
                        Group group = new Group();
                        IInfoObjects result =
                        iStore.query(
                              "SELECT SI_NAME FROM "
                              + "CI_SYSTEMOBJECTS WHERE SI_ID="
                              + memberGroups[j]);
                        IInfoObject boGroup = (IInfoObject) result.get(0);

                        int groupID = boGroup.getID();
                        String groupTitle = boGroup.getTitle();
                        String groupDescr = boGroup.getDescription();

                        group.setId(groupID);
                        group.setName(groupTitle);
                        group.setDescription(groupDescr);
                        groups.add(group);
                  }
            }
      }
      return groups;
}