Add join between members and societies