Let’s be more precise here. In your illustration …
Isp modem --> router --> dlink load balancing router --> computer
… I’m assuming you actually have TWO modems, each w/ its own router, and those routers are connected to the WAN ports on the dual WAN (load balancing) router. So three (3) routers in total. Or perhaps the other ISP setup is just a modem (no router). Doesn’t matter.
As far as the dual WAN router is concerned, each WAN is connected to some other network. It doesn’t give a hoot how that network is configured, whether it’s a modem, another router, switch, whatever. All it knows is that it’s been told to load balance traffic between the two WANs, and/or use one as the primary and the other as a failover. So in that sense, it’s dumb. It just does what you tell it to do w/ those WAN ports. Of course, *hopefully*, given your intended usage, each WAN provides a pathway to the Internet!