[SPARK-3634] [PySpark] User's module should take precedence over system modules

Python modules added through addPyFile should take precedence over system modules.

This patch put the path for user added module in the front of sys.path (just after '').
The `.py` files will be put in `root_dir`, can be imported by name, so it should not put in sys.path.