When deleting groups/users, delete corresponding group memberships, permission set assignments, etc.

[CarlosCuevas]

Is your feature request related to a problem? Please describe.
If a user is deleted from AWS, there will remain a reference to that user within the group. Same for both users and groups which were assigned particular permission sets.

Describe the solution you'd like
Cascade delete foreign key references