SELECT * FROM(SELECT c.*,a.nickName FROM comment c JOIN account a ON c.userId = a._id AND c.contentId = 30) a order BY commentGroup ASC,root asc,_id asc;
SELECT * FROM(SELECT c.*,a.nickName FROM comment c JOIN account a ON c.userId = a._id AND c.contentId = 30) a order BY commentGroup ASC,root asc,_id asc;