mysql自动分配id_mySQL：为双选查询分配自动增量ID号

我正在创建一个程序，我从一个表中选择的数据被随机分组 . 每个组中的RegistrationID号被保存到另一个表中(作为外键)，并为每个组成员分配一个groupID，该ID随创建的每个新组自动递增 .

$GroupSize = $_POST['groupsize'];

//Connect to the Server+Select DB

$con = mysqli_connect($host, $user, $password, $dbName) or die("Nope");

if (isset($_POST['create'])) {

//assign group id to groups created

//insert groupinformation to table from userInformation

$query = "SELECT RegistrationId FROM (Select * from userInformation order by RAND() LIMIT ".$GroupSize.") INTO groupInformation";

$result = mysqli_query($con, $query) or die ("query failed" . mysqli_error($con));

//display group and information

echo "

echo "

RegIdNameAddressEmail";

while (($row = mysqli_fetch_row($result)) == true) {

echo "

$row[