MySQL - Call a View inside a Stored Procedure
... I was told to create a stored procedure, and call the view inside it.

You don't need a View.
You don't need a Stored Procedure.
Just select the data that you want to display, based on the criteria that you have.
select id, name, status, usertype, flag 
from tbl_1 
where usertype = ?
order by id ; 

The usertype argument will come from [the value of the selected &quot;option&quot; element within] the &quot;select&quot; element.
Depending on how your page(s) are structured, you might need an AJAX request to get the data or submitting a form containing the &quot;select&quot; element and processing that.