If you run your own lightning node and open a channel with another node, there is no fee needed. If you depend on people's channel, or not connected directly to someone, you will need to pay little amount in fee.
As an example, for a 0.027BTC transaction the fee I paid was 0.000164BTC which is comparable to the on-chain fee.
This is not possible as of now.