danci/www.hanlinyuanonline.com/Application/Admin/Model/UserConnectModel.class.php

<?php
namespace Admin\Model;
use Think\Model;

class UserConnectModel extends Model
{   
    public function getConnectUserList($userId, $page, $pageSize){
        $sql = sprintf("SELECT user_Id FROM (SELECT `friend_id`,`ref_user_id` AS user_id FROM `t_friend` WHERE `user_id` = '%d' UNION ALL SELECT `friend_id`,`user_id` AS user_id FROM `t_friend` WHERE `ref_user_id` = '%d' ORDER BY user_id DESC) A LIMIT %d,%d",$userId, $userId, $page, $pageSize);
        return $this->db->query($sql);
        //return M('Friend')->where(array('user_id|ref_user_id'=>$userId))->field('user_id,ref_user_id')
    }
}