循环查询问题

我需要连接四张表， 

select o.orderId,u.nickName,o.serveCount,(select u.nickName from user u where u.shortUrl=o.shortUrlServer) nname ,

(select ((count(*) * (total - counterFee))*0.03)) b,-- f交易奖励

(select (count(*) * (total - counterFee))) a,-- 服务费

(SELECT (total - counterFee)) c,e.evaTextContent,e.evaLevle 

from user u 

INNER JOIN orders o on o.shortUrlUser = u.shortUrl 

left JOIN serve s ON o.serveId=s.serveId 

LEFT JOIN evaluate e on e.orderId=o.orderId; 

现在想取到每一个人（nname）的订单的唯一值，就是统计每一个人的serveCount，这个怎么实现循环查询