根据查询未读的活动评论或回复

– 根据查询未读的活动评论或回复

select t1.id, pid, t1.`status`, t1.user_id , t2.avatar , t2.nick_name , content , t3.title, CASE 
	WHEN pid is null THEN
		'reply'
	ELSE
		'comment'
END as type,
CASE WHEN pid is null THEN
	null
ELSE
		(select content from cms_activity_comment t where t.id = t1.pid)
END as parent_content
from cms_activity_comment t1
left join cms_user t2 on t1.user_id = t2.user_id
left join cms_activity t3 on t1.aid = t3.id
where t1.tid=116 and t1.`status`='1'