Usage of Stored procedures/function in laravel | Learning Curve- Perfect Tutorial for the beginers

Stored procedure/function as like below

DROP FUNCTION `number_of_employees`
CREATE DEFINER=`mydatabase`@`localhost` FUNCTION `number_of_employees`(branch_id_input INT) RETURNS int(11)
BEGIN

  DECLARE number_of_employees_count INT;

  
  select count(*) INTO number_of_employees_count from tbl_employee
  join branch on branch.emp_id=tbl_employee.branch_id
  where branch_id= branch_id_input;

 

  RETURN(number_of_employees_count);

END

DROP FUNCTION `number_of_employees`

CREATE DEFINER=`mydatabase`@`localhost` FUNCTION `number_of_employees`(branch_id_input INT) RETURNS int(11)

BEGIN

DECLARE number_of_employees_count INT;

select count(*) INTO number_of_employees_count from tbl_employee

join branch on branch.emp_id=tbl_employee.branch_id

where branch_id= branch_id_input;

RETURN(number_of_employees_count);

END

Above stored fuction will execute and it will be saved in the database.We can see this in the phpmyadmin

how to use the above function in the laravel eloquent model as like below,

<?php

public static function listEmployees($branchid,$empid) {
$employee->addSelect(DB::raw("number_of_employees($empid,$branch_id) as total_employees"));
}
?>

<?php

public static function listEmployees($branchid,$empid) {

$employee->addSelect(DB::raw("number_of_employees($empid,$branch_id) as total_employees"));

}