ПДО несколько lastinsertid

---

Running the following code using PDO.

I need to insert multiple queries like lastInsertId from size table into stock table.

Size Table

ID Size Price

1 S 100
2 M 100
3 L 100


Stock table

Size_id Qty

1 1
2 1
3 1

$conn->beginTransaction();
$sql = $conn->prepare("INSERT INTO size (sname, sprice) VALUES (:size,:sizeprice)");
foreach( $size as $key => $n ) {
$size1 = $n;
$size2 = $sizeprice[$key];
$sizeid = $conn->lastInsertId();
$sql->bindValue(':size',$size1);
$sql->bindValue(':sizeprice',$size2);
$sql->execute();
}
$sql1 = $conn->prepare("INSERT INTO stock (size_id, qty) VALUES (:size_id,:qty)");
foreach( $qty as $key1 => $nn ) {
$qty1 = $nn;
$sql1->bindValue(':size_id',$sizeid);
$sql1->bindValue(':qty',$qty1);
$sql1->execute();
}
$conn->commit();
echo "New records created successfully";

<form action="" method="POST">

    <button class="add_field_button">Add New Input</button>
	<div>Size<input type="text" name="size[]"></div>


	<div>Size Price<input type="text" name="sizeprice[]"></div>
    </div>
	
	<div>Qty<input type="text" name="qty[]"></div>
    </div>
	
    <div class="input_fields_wrap">

	</div>
    <button type="submit" name="submit" class="inner">Save</button>
</form>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script>
$(document).ready(function() {
    var max_fields      = 10;
    var wrapper         = $(".input_fields_wrap");
    var add_button      = $(".add_field_button");

    var x = 1;
    $(add_button).click(function(e)
    {
        e.preventDefault();
        if(x < max_fields)
        {
            x++; //text box increment
            $(wrapper).append('<div><br>Size<input type="text" name="size[]"/><br>Size Price<input type="text" name="sizeprice[]"/><br>Qty<input type="text" name="qty[]"/><a href="#" class="remove_field">Remove</a></div>');
        }
    });

    $(wrapper).on("click",".remove_field", function(e)
    {
        e.preventDefault(); $(this).parent('div').remove(); x--;
    })
});
</script>

Что я уже пробовал:

Running the following code using PDO.

I need to insert multiple queries like lastInsertId from size table into stock table.

---