如何使用外键将多个查询插入到不同的表中

Question

How to insert Multiple Query into different tables with foreign key? I have below code, would anyone help me to modified below code!

 $query = "INSERT INTO student(fname, lname, phone, email,status) VALUES('".$_POST["fname"]."','".$_POST["lname"]."','".$_POST["phone"]."','".$_POST["email"]."','".$_POST["status"]."')";
        $res = $db_handle->executeQuery($query);
    if(!$res){
            $message="Please try again!.";
    } else {
        header("Location:index.php");
    }
}

my Tables: student, course, schedule

(id_schedule, id, id_courses, schedule_year, schedule_semester) "id" connect to student table. "id_courses" connect to the id_courses into the courses table!

My DB:

--
-- Table structure for table `courses`
--


--
-- Constraints for table `schedule`
--
ALTER TABLE `schedule`
  ADD CONSTRAINT `schedule_ibfk_1` FOREIGN KEY (`id_courses`) REFERENCES `courses` (`id_courses`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `schedule_ibfk_2` FOREIGN KEY (`id`) REFERENCES `student` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;