audit – problem in query group membership with OSquery

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 a 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?