SELECT o.id, o.name as org_name, c.unify_social_credit_code as org_code, c.legal_person_name as legal_person_name, (SELECT e.tenant_user_id FROM obpm2.tenant_employees e WHERE e.organization_id = o.id AND e.is_domain_admin = 1 LIMIT 0,1) as admin_id FROM obpm2.tenant_organizations o left join obpm2.tenant_companies c on o.id = c.id where o.id = #{bcxOrganizationId} SELECT u.id, u.name as user_name, c.number as id_card_no, u.telephone as mobile FROM obpm2.tenant_users u left join obpm2.tenant_user_credentials c on c.tenant_user_id = u.id and c.credential_type = 0 where u.id = #{userId} SELECT u.id, u.name as user_name, c.number as id_card_no, u.telephone as mobile FROM obpm2.tenant_users u left join obpm2.tenant_user_credentials c on c.tenant_user_id = u.id and c.credential_type = 0 left join obpm2.tenant_employees e on e.tenant_user_id = u.id where e.id = #{employeeId} INSERT INTO obpm2.shared_messages(id, sender_id, business_number, content, created_time, message_type, receiver, receiver_type, status, title, unique_id) VALUES( #{id}, #{senderId}, #{businessNumber}, #{content}, #{createdTime}, #{messageType}, #{receiver}, #{receiverType}, #{status}, #{title}, #{uniqueId} )