I have a membership database I am converting into a phpRunner project. Each paid member is able to have a handful of free associated memberships. The associated memberships are still members in the main table.
I want to show a list of associated members when viewing a paid member account.
I've tried two methods of associating the data but cannot figure out how to get either to work in phpRunner.
Method 1:
I've added a "parent_member" column to the members table and populated it with the id of the paid member in each associated membership row.
Method 2:
I've created an member_association table. The first column is the parent_member id and the second column is the associate_member id with both linking back to the same id column in the main member table.
I would appreciate any suggestions on how to get a parent/child relationship view using the data from the same table.
Thanks!!!