Hello - I'm learning PHP sick

I want to delete a SPONSOR from the sponsor table.
So my query is...

$delete = "DELETE FROM sponsors WHERE id='$id'";

However, I also want to delete child records from other tables.
So I need to be able to do...

$delete = "DELETE FROM sponsors_notes WHERE sponsor_id='$id'";
$delete = "DELETE FROM sponsors_records WHERE sponsor_id='$id'";

How can I combine this into one query?
Or one MySQL statement?

n.b. - the 1st field is id, but the 2nd & 3rd are sponsor_id

Thanks laugh