Great British Bake Off co-host Sue Perkins has thanked fans for their support after revealing she has a brain tumour that means she cannot have children.