CREATE view view_feedback
as
SELECT a.id,a.user_id, a.title, a.content, a.type, a.adddate, b.repeotype, b.content AS recontent,
b.adddate AS readddate,b.flag, c.p_uname, c.p_name
FROM user_feedback as a left JOIN
user_refeedback as b ON a.id = b.f_id INNER JOIN
cu_reg as c ON a.user_id=c.p_id