select u rid r_id ruser_id r_user_id ruser_name r_user_name rdept_id r_dept_id rdept_name r_dept_name rcorp_id r_corp_id rcorp_Name r_corp_Name rposition_status r_position_status rshow_n

可以给返回参数r.开头的统一加上别名，例如：

select u.*,
        r.id as r_id, r.user_id as r_user_id, r.user_name as r_user_name, r.dept_id as r_dept_id, r.dept_name as r_dept_name, r.corp_id as r_corp_id,
        r.corp_Name as r_corp_Name, r.position_status as r_position_status, r.show_number as r_show_number, r.status as r_status,
        r.is_delete as r_is_delete, r.position as r_position, r.create_time as r_create_time, r.update_time as r_update_time,
        r.user_data_id as r_user_data_id, r.bo_id as r_bo_id, r.is_show as r_is_show, r.tel as r_tel, r.mobile as r_mobile,
        r.ds_user_dept_id as r_ds_user_dept_id, r.bo_unicode as r_bo_unicode, r.email as r_email, r.tmp1 as r_tmp1, r.tmp2 as r_tmp2,
        r.tmp3 as r_tmp3, r.tmp4 as r_tmp4, r.tmp5 as r_tmp5, r.tmp6 as r_tmp6, r.tmp7 as r_tmp7, r.tmp8 as r_tmp8, r.tmp9 as r_tmp9,
        r.tmp10 as r_tmp10, r.tmp11 as r_tmp11, r.tmp12 as r_tmp12, r.tmp13 as r_tmp13, r.tmp14 as r_tmp14, r.tmp15 as r_tmp15, r.tmp16 as r_tmp16,
        r.tmp17 as r_tmp17, r.tmp18 as r_tmp18, r.tmp19 as r_tmp19, r.tmp20 as r_tmp20
from t_user u
inner JOIN t_user_rel r on u.id = r.user_id
``