It can be done if you split out different romsets across different drives and arrange the mount points manually.
So for example I have roms on a 16gb usb and disc images (psx, segacd) and bios on a 64gb drive.
Here is an example of the set up in /etc/fstab:
LABEL=TOSHIBA16 /mnt/toshiba16 vfat defaults,noatime,umask=0000,uid=1000,gid=1000,nofail,x-systemd.device-timeout=15 0 0
/mnt/toshiba16/roms /home/pi/RetroPie/roms none bind,nofail,x-systemd.device-timeout=15 0 0
LABEL=TOSHIBA64 /mnt/toshiba64 ext4 defaults,noatime,nofail,x-systemd.device-timeout=15 0 2
/mnt/toshiba64/roms/psx /home/pi/RetroPie/roms/psx none bind,nofail,x-systemd.device-timeout=15 0 0
/mnt/toshiba64/roms/segacd /home/pi/RetroPie/roms/segacd none bind,nofail,x-systemd.device-timeout=15 0 0
/mnt/toshiba64/BIOS /home/pi/RetroPie/BIOS none bind,nofail,x-systemd.device-timeout=15 0 0