General developer forum

Below is my final code.

Note:get_recordset_sql: return multiple row, but during insertion into table it was inserting a single row.So for inserting multiple row. I have to used associative foreach loop.  foreach ($getdata as $id => $rec).

$getdata= $DB->get_recordset_sql ("SELECT name,description,descriptionformat,userid,templateid FROM  mdl_vw_new_enrolled_user_lp");

       foreach ($getdata as $id => $rec) {        

           $record = new \stdClass();

           $record ->name = $rec->name;

           $record ->description= $rec->description;

           $record ->descriptionformat=$rec->descriptionformat;

           $record ->userid= $rec->userid;

           $record->origtemplateid=$origtemplateid;

           $record ->templateid=$rec->templateid;

           $record->status= $status;

           $record->duedate= $duedate;

           $record->reviewerid= $reviewerid;

           $record->timecreated= time();

           $record->timemodified = time();

           $record->usermodified = $userid;

           $DB->insert_record('competency_plan', $record);