I've these tables users,tasks,roles,permissions & a pivot table permissions_roles. 
roles:
- role_id: auto_increament
- role_name: admin/standard
permissions:
- permission_id: auto_increament
- permission_name: create/edit/delete
Pivot table: permissions_roles
- p_id(FOREIGN KEY (r_id) REFERENCES roles(role_id))
- r_id(FOREIGN KEY (p_id) REFERENCES permissions(permission_id))
But when I'm trying to insert values into the pivot table, by writing this code:
function roles($role_name){
        mysqli_query($this->connect,"INSERT INTO roles ( role_name ) VALUES ('$role_name')");
        SET @r_id = LAST_INSERT_ID();
    }
Then I'm getting this error:
Parse error:
syntax error, unexpected '@' in /home/directory/project_folder/users.php
I need to assign multiple permissions for each roles. Please help.
 
    