ThinkPHP5 mysql存储过程

<?php
namespace app\controller\index;

use PDO;

class Procedure {
    public $_db;
    public $db_config;
    public function __construct() {
        $db_config = config("database");
        $this->_db = new PDO($db_config['type']
            .":host=".$db_config['hostname']
            .";dbname=".$db_config['database']
            .";", $db_config['username'], $db_config['password']);
        $create_procedure_sql = "....";// 在这里写存储过程语句
        $this->_db->exec($create_procedure_sql );
    }

    // 外部调用方法
    public static function run_procedure($id)
    {
        $retrieve = new Procedure();
        $query = $retrieve->_db->prepare("call method(?)");
        $query->execute(array($id));
        $ret = $query->fetchAll();
        return $ret;
    }
}