Forward $LOCAL_PORT from the local machine (-L), to $TARGET_HOST on $TARGET_PORT, relative to $REMOTE_HOST:
ssh -L $LOCAL_PORT:$TARGET_HOST$:$TARGET_PORT $REMOTE_USER@$REMOTE_HOST(Traffic flows from localhost:$LOCAL_PORT → $REMOTE_HOST → $TARGET_HOST:$TARGET_PORT.)