To use a keyboard which only has a USB to host (USB B) port on it to control another sound source, the device at the end of the cable (B -> A) needs to one which controls the USB bus. The word for such a device is a host.
That explains why the port is labelled 'to host' in the first place.
The traditional thing to use as a host is a computer.
There are however other devices which are not fully fledged computers which can be a USB host for MIDI. These devices have a USB A port on them just like computers do and then other ports to send/receive the MIDI data onward to something else.
In USB (ignoring newer stuff with USB-C) the host is the thing expected to provide any power to devices (if needed) but never the other way around. So a USB host device will always need its own power supply.
For Midi over USB the host device requires 'drivers' to be able to understand the MIDI device, but since MIDI is very common most devices work with the same 'driver' as any other. A person with a computer would never need install this 'driver' as it is baked into the OS. Using this common driver is what is known as being Class Compliant.
So putting all this together, it would stand to reason that a computer substitute device could be made. It would have a USB-A port on it. A power input port, plus some way of getting the MIDI in/out of it, such as a pair of 5 pin DIN ports.
These devices exist and are called "USB MIDI Hosts" and would be how somebody would use say a Digital Piano with USB-B only to control a synth that has DIN MIDI IN. This would work for you. You power the box, connect it via an A to B cable to the controller and use a MIDI DIN cable to the CK61.
Many USB host boxes do support hosting more than one USB keyboard when used with a USB 2.0 hub so even if the CK61 was a different board with no legacy MIDI ports and just USB-B then a MIDI host box + HUB is still possible to join two USB-B only boards together. Some may support being powered by one of the A ports as power source only negating the need for a separate power supply.
The most well known USB Host is made by Kenton and is the most expensive, but others exist and start around the $50 mark.
Given the Yamaha CK61 is very modern I thought that perhaps it may have a MIDI implementation on it's USB A [to device] port. Hardly any keyboards support this but I have a Dexibell which does.
The manual disagrees with this and says the [to device] port supports only mass storage.
9 USB [TO DEVICE] terminal (CK61 and YC61 say this)
For connecting a USB flash drive to the CK, allowing
you to save a Live Set Sound you have stored, load a
Live Set Sound back to the CK, or play audio files.
There is no harm in trying an A to B (USB printer cable) cable in with the A end in the CK61 and the B end in the controller. It may well work, despite what the manual says but the OS of the keyboard would have needed to be written to support that. It could be the sort of thing to be added in a firmware update later perhaps. For the CK/YC series especially the ability to plug in a cheap USB MIDI only controller to use as the lower manual would be nice.
Lack of MIDI on the host [to device] ports is in many respects a reason why USB MIDI has never replaced traditional DIN MIDI in computer-less setups. Having IN+OUT over the same wire and not being able to physically understand what's going where in a live situation is another reason.
In effect what you want to do is bridging two worlds (studio vs live) so requiring a bridging device is not that surprising.