You should be able to use a join. Probably a left join just in case there isn't a record in one of the child tables. So, something like this:

SQL Query
delete sponsors, sponsors_notes, sponsors_records
from sponsors
left join sponsors_notes on sponsors_notes.sponsor_id = sponsors.id
left join sponsors_records on sponsors_records.sponsor_id = sponsors.id
where sponsors.id = '$id'