我有一个WordPress多站点，需要从该站点提取信息。我编写了一个存储过程，它递归地为某种帖子构建树关系。现在我想知道如何将存储过程推送到所有站点的数据库中。（由于这是一种多站点配置，因此每个站点（本例中的子域）都有一个单独的数据库。）

请在这方面帮助我。

WordPress版本：3.5.1多站点配置类型：子域

//code needs refinement

DELIMITER //
CREATE PROCEDURE getPath(IN post_id INT, IN return_path TEXT)

BEGIN

 DECLARE done INT DEFAULT 0;
 DECLARE a INT;
 DECLARE b TEXT;
 DECLARE cur1 CURSOR FOR (SELECT * FROM TempTable112);     
 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
 DROP TABLE IF EXISTS TempTable112;

 SET max_sp_recursion_depth := 10;

 CREATE TEMPORARY TABLE TempTable112 AS SELECT id,post_title FROM wp_101_posts WHERE post_parent = post_id and post_status=\'publish\'; 

SET @s = CONCAT(\'SELECT * INTO OUTFILE \',"\'", CONCAT(\'Sample\',FLOOR(1000+RAND()*9999)),\'.txt\',"\'",\' FROM TempTable112\');
PREPARE stmt2 FROM @s;
EXECUTE stmt2;
DEALLOCATE PREPARE stmt2;

    OPEN cur1;

read_loop: LOOP
    FETCH cur1 INTO a,b;
    IF done = 1 THEN
      LEAVE read_loop;
    END IF;
         SET return_path = CONCAT(\'/\',return_path,b);
     CALL getPath(a, return_path);
  END LOOP;
  CLOSE cur1;
END //

DELIMITER ;