sqlite3 like语句注意事项
SQLITE文档中有说明啊，like %这个要转义，加‘’，字符串连接用 ||


select L.p_id AS pa_id, R.p_id AS ch_id FROM PV as L inner join PV as R on L.v_id = R.v_id and L.p_id <> R.p_id
where R.value LIKE L.value||'%'