MYSQL multi-table join insertion data problems, please help, dead...

MYSQL multi-table join insertion data problem, please help, anxious ...... I inserted A piece of data in Table A, where the ID field automatically grew, and then I used mysql_insert_id (); to obtain the ID of the data just inserted, then insert several pieces of data into Table B using the FOR loop. the ID of Table B is the problem of using mysql_inser MYSQL multi-table Association to insert data ......
I inserted A piece of data in Table A, where the ID field automatically grew, and then I used mysql_insert_id (); to obtain the ID of the data just inserted, then insert several pieces of data into Table B using the FOR loop. the ID of Table B is obtained by mysql_insert_id ();, and the program appears at the beginning of internal testing, the ID of the data inserted into Table B of employee a Becomes the ID of the employee, which is confusing. please give me an idea how to solve this problem, the ID of Table A is the same as that of Table B. thank you ......

------ Solution --------------------
This problem may occur during concurrency. use transaction. if transaction is not supported, use the lock.