123456789101112 |
- <?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')
- }
- }
|