How, after entering data into the fields of two tables, to transfer the id of these fields to the third table?

Question

PHP

There are three tables:

Logic:
When checking into a hotel, all fields in all three tables are filled in, but you need to do something like this:

• information about the payment is sent to the table payments, and id_paymentthis payment is sent toaccommodation
  
• information about the new guest is sent to the table clients, and id_clientthis guest is sent toaccommodation
  

Those. in fact, you need to take the data, write it to tables, and then enter the id-shniks of this data into the table accommodation.
How is this implemented?