in that case, you don’t need a separate table, just add appointedby to users – this means each user is appointed by only one user, but one user can appoint multiple users
for a true many-to-many relationship (one user can appoint multiple users, and one user can be appointed by multiple users), you would keep your separate table