This is my code inside execute function
public function execute() {
global $DB;
$sql = "Insert INTO mdl_competency_plan (name,description,descriptionformat,userid,templateid,timecreated,timemodified)
Select name,description,descriptionformat,userid,templateid,timecreated,timecreated from vw_new_enrolled_user_lp";
if ($DB->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$DB->close();
}