select JSON_OBJECT(
        'id', t.contract_id,
        'code', t.contract_code,
        'contract_remark', t.contract_remark,
        'other_remark', t.other_remark
    ) AS json_result
from biz_contract AS t where t.del_flag = '0'
and t.counsel_user_id = (select user_id from sys_user where del_flag ='0' and user_name = '黄文荣');