Why is it in the same table as the user names if it applies to the account?

Or are you joining in SQL then unjoining in Perl?

Either way, seems odd to me.

See Re: Grouping an array of hashrefs by similar key values.