just run a DELETE statement. so something like:
so that would delete everything in pending_tbl where the pending_id (assuming that was your id column) is 1, 2, 3, or 4.
DELETE FROM pending_tbl WHERE pending_id IN ( 1, 2, 3, 4 )
if you want it more advanced, i would probably do something like this for each record:
so that would require you to have 2 additional columns in pending_tbl: members_id and members_date. members_id would reference the id number assigned to the transferred record. members_date would just track what day the transfer was made.
INSERT INTO members_tbl
WHERE pending_tbl.pending_id = 1;
SET members_id = LAST_INSERT_ID(),
members_date = NOW()
WHERE pending_id = 1;
i would probably have the records in pending expire after like 2 days post-transfer. that way, if there are any problems you can go back to the pending table and reconcile the issues. but you're not keeping the additional data around for too long.
clearly then, you would only be able to approve pending_id numbers where the members_id IS NULL.