id_, group_id_, device_id_ SELECT d.* FROM device_info d LEFT JOIN device_relation_group rg on rg.device_id_ = d.id_ where rg.group_id_ = #{groupId}