IndexAction::_post_recommend PHP Méthode

    private function _post_recommend($limit)
    {
        $db_prefix = C('DB_PREFIX');
        $sql = "SELECT a.* FROM `{$db_prefix}weiba_post` a, `{$db_prefix}weiba` b WHERE a.weiba_id=b.weiba_id AND ( b.`is_del` = 0 ) AND ( a.`recommend` = 1 ) AND ( a.`is_del` = 0 ) ORDER BY a.recommend_time desc LIMIT " . $limit;
        $post_recommend = D('weiba_post')->query($sql);
        $weiba_ids = getSubByKey($post_recommend, 'weiba_id');
        $nameArr = $this->_getWeibaName($weiba_ids);
        foreach ($post_recommend as $k => $v) {
            $post_recommend[$k]['weiba'] = $nameArr[$v['weiba_id']];
            $post_recommend[$k]['user'] = model('User')->getUserInfo($v['post_uid']);
            $post_recommend[$k]['replyuser'] = model('User')->getUserInfo($v['last_reply_uid']);
            $images = matchImages($v['content']);
            $images[0] && ($post_recommend[$k]['image'] = array_slice($images, 0, 5));
            /* 解析emoji */
            $post_recommend[$k]['title'] = formatEmoji(false, $v['title']);
            $post_recommend[$k]['content'] = formatEmoji(false, $v['content']);
        }
        // dump($post_recommend);exit;
        $this->assign('post_recommend', $post_recommend);
    }