以ThinkPHP为例：
$User = M(‘user‘); $map = array(.......);//查询条件 $ids = $User->where($map)->limit(100)->getField(‘id‘, true); shuffle($ids); $map = array(‘id‘=>array(‘in‘, array_slice($ids, 0, 10)));//打乱并取出10个id $_result = $User->field(‘id,name,nick‘)->where($map)->select();
原文：http://www.cnblogs.com/smismile/p/5285640.html