INSERT INTO student (id_name1, id_name2, id_name3, id_university, id_faculty, id_speciality, id_passport, id_adress)
SELECT names1.id, names2.id, names3.id, universitys.id, facultys.id, specialtys.id, passports.id, adresss.id
FROM (SELECT name1.id FROM name1 ORDER BY RAND() LIMIT 5) as names1,
	 (SELECT name2.id FROM name2 ORDER BY RAND() LIMIT 5) as names2,
     (SELECT name3.id FROM name3 ORDER BY RAND() LIMIT 5) as names3,
	 (SELECT university.id FROM university ORDER BY RAND() LIMIT 5) as universitys,
	 (SELECT faculty.id FROM faculty ORDER BY RAND() LIMIT 5) as facultys,
	 (SELECT specialty.id FROM specialty ORDER BY RAND() LIMIT 5) as specialtys,
	 (SELECT passport.id FROM passport ORDER BY RAND() LIMIT 5) as passports,
	 (SELECT adress.id FROM adress ORDER BY RAND() LIMIT 5) as adresss
		ORDER BY RAND() LIMIT 10;