forensics – problem in OSquery result

I’m trying to query all group members for a specific user in OSquery. but as result, I just got one group and all group does not show.
for example, I create a user named “test” and member of “administrators” and ” users ” and then I query “select * from users where username like ‘test’;” and see one gid (for example 514).
the question is, why I could not see two gid?

anybody help?